www.hkvforums.com

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)

Recordset_Selecting is not for reports. For reports, you may try Page_Selecting.

This is not a report, so there is no Page_Selecting event.

This is normal table, where you can add chart in the Chart tab so the generated script will show both the Chart and the data

Then you may try set your filter to $this->Filter of the page for the chart to get. Note that $this->Filter is a page property, it is not same as the $filter (argument of Recordset_Selecting) in your first post. You may try Recordset_Selecting and set $this->Filter = $filter.

I didn't change anything. It is fixed now debug shows the query result is now same for both the data and chart.