PHPMaker v2024.9
DB: MSSQL 2017
I put the following code in Recordset_Selecting:
function Recordset_Selecting(&$filter)
{
// Enter your code here
$filter = str_replace('[TransactionDatetime]', 'convert(varchar(10),[TransactionDatetime],120)', $filter);
}
The TransactionDatetime search operator is set to "BETWEEN". In debug mode, I can see the filter is applied to the report but not to the chart query.
Meaning to say, I can see data in the List page, but the chart is not shown because the query for the chart is empty (because the filter was not applied to it)