Re: SYS Is not in query ?

Mark Roethof · ‎03-26-2024

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

Kind regards,

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

sukran · ‎03-26-2024

exit.trigger_id = returns sys id as expected

James Chun · ‎03-26-2024

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

Ver la solución en mensaje original publicado

sukran · ‎03-27-2024

Its works with mentioned code

var usrLoc=[];

addEncodedQuery("sys_idNOT IN"+usrLoc);

Passing the value to array ,then its looks good

Mark Roethof · ‎03-26-2024

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.

Kind regards,

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field