how to fetch filter values in report for ROQL query
Summary
fetch filter values in report for ROQL queryContent
Hi ,
Please help me. I need it urgent.
I am trying to fetch filter values from report to be used in Custom script for ROQL query filtering.
I used the following code in init tab
global $filters;
$filters = print_r($params, true);
-------------------------------------------------
I used the following code in Process tab
$val1 = $params["search_args"]["search_field0"]["val"]; //dept
$val2 = $params["search_args"]["search_field1"]["val"]; //Incident Type
$val3 = $params["search_args"]["search_field2"]["val"]; //Form Type
$val4 = $params["search_args"]["search_field3"]["val"]; // Created Date Range
$query1 = "select count(*) cnt1 from CO.TagIncident T join T.TagIncidentID I where T.TagList.LookupName = '" . $rows[0][0]->val . "' and i.createdTime between date_add(sysdate(), " . $val1. " ,'day',1) and sysdate() " ;