What does' sys_idIN' mean when used in a query? Eg : 'active=true^sys_idIN' + function( )

[Rama Chandra D]

I'm trying to figure out a script which has the syntax mentioned in the question, that is 'active=true^sys_idIN' + function( ). Can someone explain to me what does sys_idIN do here? Does it simply include the sys_id passes to the query as one of the a condition?

[Rama Chandra D]

This worked, but can you tell me how toArray().join() made the difference?

[Abhinay Erra]

getMyGroups() does not give you sys_id's directly. It gives you an iterator

to the list of groups. You need toArray() method to convert it to an array

and then use join() to get the coma separated contents of the array

On Friday, August 19, 2016, darshak <community-no-reply@servicenow.com>

[Rama Chandra D]

Thank you

[Rama Chandra D]

One more thing, when I didn't use the change you suggested, I was able to list two groups among the many a user is member. Like if a user is a member in 4 groups or 3 groups, only 2 of them is always displayed. Does it have to do with the way with data handled and the limitations in the size of variables?

[Abhinay Erra]

It will return you undefined values when you just use getMyGroups().