Passing Run-time selectable Date Range Filter to Custom Script of the Report
Content
I have passed the run-time selectable date range filter to Custom Script of the Report. I have taken the FROM date and TO date in two variables convertiing epoch time in UTC format, In the ROQL query if I give static date range like this,
Static Query:
$query = \RightNow\Connect\v1_4\ROQL::queryObject("SELECT CO.PaymentTransaction FROM CO.PaymentTransaction WHERE CO.PaymentTransaction.TransactionDate BETWEEN '2020-05-01T17:49:48Z' AND '2020-05-31T17:49:48Z' AND CO.PaymentTransaction.incidentID= ".$incID)->next(); I'm getting the results for this
but in order to make this dynamic I'm providing the variables that holds the selected date range from the Docked Filter, while doing that it is returning empty results.
Tagged:
1