Reports- is there a IS NOT ONE OF option?

Not applicable

I have a report using a javascript for one of the filters (it returns a string of sysids). I'm trying to get my report to EXCLUDE the sysids in this list but it only excludes the first 2.

In testing, I turned the report around and did SYSID IS ONE OF javascript:getLicensedUsers() and it showed all the users it should! The problem I can't figure out is how do I get a list of sysids to exclude? It looks like all the other options only work for the first one or two sysids and stops working.

What option do I have to do something like SYSID IS NOT ONE OF javascript:getLicensedUsers()?

UPDATE:
I found that if I'm on the list view of the user table the same results happen. If I say SYSID IS ONE OF javascript:getLicensedUsers() it works beatifully but I don't have a way of doing the opposite of that.

3 REPLIES 3

CapaJC
ServiceNow Employee
ServiceNow Employee

incident_list.do?sysparm_query=sys_idNOT%20INd71f7935c0a8016700802b64c67c11c6,d71da88ac0a801670061eabfe4b28f77,d71b3b41c0a8016700a8ef040791e72a


Not applicable

Hi CapaJC,

Thank you for the response.

I don't see NOT IN as a selectable operator. Is there something I need to do to unlock it or something?


CapaJC
ServiceNow Employee
ServiceNow Employee

You won't find it in a filter, as far as I know. My use of it is limited to building an encoded query via script (for a reference qualifier, for example).