Reference Qualifier on Lookup Select Box Variable

Blair5 · ‎03-02-2015

I've been looking through the WIKI/community and it seems like there is a bug with reference qualifiers on Lookup Select box variables. Does anyone know if there is a work around besides making the field a reference variable?

I have 3 variables on a form -- each dependent on the last. The first is a lookup select box and I'd like the second to be a lookup select box with a reference qualifier because setting it as a reference variable gives the same information as the third variable. I've tried only showing the columns I want (with attributes), but it still shows too much.

Is there another angle I can take? Building the list with a script? I only want to show unique values. Any ideas/help would be greatly appreciated because I think I've exhausted all the options I can think of. Thanks!

Kalaiarasan Pus · ‎03-03-2015

Seems like we all have been trolled here Look up select supports reference qualifier but it's not simple as reference field..

Check the wiki page

http://wiki.servicenow.com/index.php?title=Variable_Types#Lookup_Select_Box

We need to use 'ref_qual_elements' attribute to get the updated reference working..

I am able to do the dynamic thing working after adding the attribute...

Sample demo:

Create 2 lookup select variable called 'located_at' and 'user' referring location and user table respectively.

Idea here is to display the user depending on the location selected...

In the user variable, define reference qual as javascript: 'location='+current.variables.located_at; and variable attribute as ref_qual_elements=located_at

This will make the variable to use the updated reference. Try this out and let me know if this works for you as well.

Note: I tried on Fuji instance.

View solution in original post

rohanhemadee · ‎12-09-2015

You can put it in a reference qualifier condition into the lookup Select box. In Eureka 11 what I did what chose the field type as reference put in the simple qualifier condition and then converted field back to lookup select box. The system handles the conversion and creates the encoded query for you.

I guess my requirement was a bit different to your but it shows a way to put in simple qualifier conditions for lookup select box.

sidarth · ‎06-10-2016

Does it work on Geneva? I am unable to make it work

SC10 · ‎06-10-2016

Myself included... The new Geneva docs don't mention anything beyond setting the attribute, so I am not sure what else needs to be done.

I've reached out to HI support and am waiting on an answer at this point.

sidarth · ‎06-12-2016

I made it to work out.

It works wonderfully.

Do let me know if you need help

SC10 · ‎06-13-2016

Good day,

If you could please share how you got this to work I'd appreciate it.