Hello,

I have a query that i am trying to run (See Below), however the query comes back with an error -

Error

unknown [expr_type] = reserved in "WHERE" [4]

The query i am executing is -

SELECT DATE(`created`) AS created_date, `Extension`, SUM(CASE WHEN `Call_type` = "Incoming" AND `Extension` != 2504 THEN 1 ELSE 0 END) AS CallsAnswered, SUM(CASE WHEN `Call_type` = "Incoming" AND `Extension` = 2504 AND `Dialed_digits` LIKE 'R%' THEN 1 ELSE 0 END) AS CallsRecieved FROM mp_wp_call_report_pstn WHERE `created` BETWEEN NOW() - INTERVAL 31 DAY AND NOW() GROUP BY DATE(`created`) ORDER BY `created` ASC LIMIT 0, 32

Removing the "INTERVAL 31 DAY" resolves the issue and allows the query to proceed. However when processing this manually on MYSQL, the query works without issue and provides the relevant data.

Is there a way you have to specify an interval or is this not supported in wpDataTables ?

Regards,

Matt