SYS Is not in query ?

[sukran]

In Server side background script how to query glide record ... Sys Id is not ..

Below query is not working

var rec = incident.sys_id ( stored incident sysid records)

addQuery('sys_id , '!=', rec);

ANY IDEA

[Harsh_Deep]

Hello @sukran 

Please use below code

rec.addEncodedQuery('sys_id!='+rec);

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

[sukran]

Hi Harsh

rec.addEncodedQuery('sys_id!='+rec); its not returning correct data 

For Testing (I queried addQuery('sys_id' , rec) = > Its looks good 

But != condition not working 

[AshishKM]

can you post complete script code.

[sukran]

My Script code 

var exit = new GlideRecord('asmt_assessment_instance');

exit.addQuery('metric=22402a93030393976') // Metric rating

exit.query();

while(exit.next()){

var rec = exit.trigger_id ; // Sys id of engagement

var eng = new GlideRecord('sn_vdr_risk_asmt_vendor_engagement');

eng.addQuery('sys_id' , '!=' , rec);   ( Tried 'sys_idNOT IN ' +rec  and ('sys_id!='+rec)

eng.query();

while(eng.next()){

gs.print(eng,name);

}

}