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

[Mark Roethof]

Did you also debug exit.trigger_id, does it contain the value you would expect?

[sukran]

exit.trigger_id = returns sys id as expected

[James Chun · Accepted solution]

Hi @sukran,

Use the following query instead:

addEncodedQuery('sys_idNOT IN'+rec);

I am assuming the 'rec' variable is an array which stores the sys_ids.

Cheers

[sukran]

Its works with mentioned code

var usrLoc=[];

addEncodedQuery("sys_idNOT IN"+usrLoc);

Passing the value to array ,then its looks good

[Mark Roethof]

It should be able to work. The other suggestions are fine to. Question is more, is the other content in your query valid, did you verify? For example "rec", is that valid? Did you debug?

What can you share.