advanced reference qualifier on a reference field?

[bigbacon]

Is this possible? I am not sure how to go about what I'm trying to do. 

I want to create a refence field that has only specific choices but I need that choice list to be dynamic based on a "Where something in (select something from other table)"

Is that even possible to do? We have a table that is more or less a lookup but we now need to get a User reference instead of just using that lookup table for choices so the reference field to User needs to only shows those specific selections.

[Sandeep Rajput]

@bigbacon Please refer to this thread https://www.servicenow.com/community/developer-forum/reference-qualifier-based-on-the-other-field-va... a similar question has been answered here as well https://www.servicenow.com/community/itsm-forum/advance-reference-qualifier-depending-on-other-field...

[PritamG]

Yes, it's possible.

You can use a dynamic filter option on the reference field in ServiceNow. Configure the reference qualifier with a script or query that dynamically filters the User table based on your conditions (e.g., "WHERE something IN (SELECT something FROM another table)").

[bigbacon]

I don't seem to be able to do the advanced qualifier on a reference field. thats why I asked the question. I can only use the simple way. See screenshot.

[Ankur Bawiskar]

@bigbacon 

you can use advanced reference qualifier on that field and fetch the data/records

what did you try so far and what didn't work?

Please share the script and screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.