Issue with variable - users with empty location not possible to find
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-01-2023 04:47 AM - edited ‎12-01-2023 04:47 AM
Hi All
I have a variable 'Requested for' and it reference to sys_user table. I've added the simple reference qualifier to exclude users whose location is 'Hamburg' but I have an issue that users without location (location is empty) are also not possible to find, but they should be visible. Maybe you know what can cause it?
Default value for this variable is: javascript: gs.getUserID()
Thanks in advance for help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-01-2023 05:22 AM
your simple ref qualifier must be like this
Location [IS NOT] Hamburg
So add this along with it so that it shows users with empty location. Remember you need to discuss with your customer whether they want to show users with empty location if any subsequent process is using this location value
Location [IS NOT] Hamburg
OR
Location [IS EMPTY]
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader