Using reference qualifier to filter users based on the current user's location

JordyZ · ‎11-30-2022

Hi, I have a variable on a catalogue item that references the sys_user table. I'd like that variable to only show the users that are in the same location as the current user's location (i.e current user is European so he will only see European users). How do I do this with reference qualifier?

I've found a post that resembles this problem, but not entirely. I'm new to ServiceNow, so I don't know yet how to tweak the answer to fit my specific case.

https://www.servicenow.com/community/it-service-management-forum/reference-qualifier-to-filter-locat...

Rebecca3 · ‎11-30-2022

There is a much easier way to do this, without requiring a script include.

gs.getUser().getLocation() returns the location of the logged in user. In the reference qualifier of your variable, you can use it as follows -

 javascript&colon;gs.getUser().getLocation()

View solution in original post

JordyZ · ‎11-30-2022

Hi @Kalyani Jangam1 @Mitsua

I am still getting an error even after including the two first lines. What am I doing wrong? Thank you for your patience guys.

Kalyani Jangam1 · ‎11-30-2022

Hi @JordyZ

Create new SI and make client callable false and refer below

Try this one for new SI and let me know if it is working or not.

Mitsua · ‎11-30-2022

Hey @JordyZ

In your code last line was missing. (type: 'populate_users')

I am attaching here xml of script include.

Please check once by importing it.

Thanks!

Mitsua · ‎11-30-2022

Hello @JordyZ

Please refer attached screenshot for reference. You script include look like :

Reference qualifier :

Please mark my response as Correct / Helpful based on Impact.

Thanks!

Kalyani Jangam1 · ‎11-30-2022

Hi @JordyZ

Please refer below scrrenshot

Screenshot 2022-11-30 at 4.19.36 PM.png

Please check and mark answer correct if it will help you.