Reports- is there a IS NOT ONE OF option?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2013 01:17 PM
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.
- Labels:
-
Orchestration (ITOM)
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-26-2013 01:33 PM
incident_list.do?sysparm_query=sys_idNOT%20INd71f7935c0a8016700802b64c67c11c6,d71da88ac0a801670061eabfe4b28f77,d71b3b41c0a8016700a8ef040791e72a

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2013 05:41 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2013 07:15 AM
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).