Report custom script

Content

Hello All,

I am using custom script in a report to update one custom field value when the report execute.

I applied my code as below what we do in php. but it not accept the RNCPHP\Incident::fetch($Incidentid);

And my roql query working fine and it return the value.

Init:

require_once(get_cfg_var('doc_root')."/ConnectPHP/Connect_init.php");
use RightNow\Connect\v1_2 as RNCPHP;
initConnectAPI();

 
 global $refno;
   $refno = $params["search_args"]["search_field0"]["val"];

 

Process Tab:

  global $refno;

 $query="Select id,AssignedTo.Account.Name as AsName from Incident where referencenumber="."'$refno'";
 $query_results = RightNow\Connect\v1_2\ROQL::query($query)->next()->next();