Help in Scripting if(gr.next()) is not working

[priya149]

After madrid upgrade this script is not working in prod, the same is working in kingston.

Below code is displaying description of incident on approval request in portal but description is not getting visible after madrid upgrade only for incident.

kindly guide if anything wrong in it.

if (record.source_table == 'incident') {
gs.log("Madrid Changes hello");
var inc = new GlideRecord('incident');
inc.addQuery('sys_id', record.sysapproval.sys_id.toString());
gs.log("Madrid Changes variable" + record.sysapproval.sys_id.toString());
inc.query();

if (inc.next())

{

gs.log("Madrid changes dsc" + inc.description.toString());
ticket.description = inc.description.toString();
ticket.comment_approval = 'true';

}

}

Logs are not coming inside if (inc.next()) and if I remove the IF condition value is not coming in  inc.description.toString();

In sort inc.description.toString(); is not working as well.

[Harsh Vardhan]

so you have any issue with addQuery(). 

do one thing try to run the above code by hard-cording the sysid and see if it it's working or not. 

run the below code in background script. 

var inc = new GlideRecord('incident');
inc.addQuery('sys_id','5f1f9d2fdb217b40c4759ef7db96196f');


inc.query();
gs.log('Row Count is'+ inc.getRowCount());
if (inc.next())

{
gs.log(inc.number);
}

[priya149]

Yes got result as

*** Script: Row Count is1
*** Script: INC1387915

[Harsh Vardhan]

if(record.source_table == 'incident') {
gs.log("Madrid Changes hello");
var inc = new GlideRecord('incident');
inc.get(record.sysapproval);
gs.log('Number is '+ inc.number);
ticket.description = inc.description;
ticket.comment_approval = 'true';

}

try now and see if it  works or not. 

[priya149]

Its coming as blank .

Number is 

Result on portal as below

[Harsh Vardhan]

try to hard-code the sysid in the script and see if it's giving the result on portal or not. 

if it works by hard-cording the sysid then try again with below script. 

if(record.source_table == 'incident') {


var op = record.sysapproval.sys_id;
gs.log("Madrid hello" + op);
var inc = new GlideRecord('incident');
inc.get(op);
gs.log('Number is '+ inc.number);
ticket.description = inc.description;
ticket.comment_approval = 'true';

}