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

sidarth · ‎06-13-2016

Sure. 1st I would like to know the steps that you took. This would help me in analyzing what you are trying to achieve

Get Outlook for Android<https://aka.ms/ghei36>

SC10 · ‎06-13-2016

Unfortunately HI Support has changed my variables in an attempt to fix the issue for me (I think it might be a bug?) and I am unable to provide you with my changes.

I had set up my variables identically to how Blair did it in page 3 - https://community.servicenow.com/servlet/JiveServlet/downloadImage/2-767166-19342/Ref_qual.jpg .

Did you do it this way? Could you share your configuration? Thanks.

sidarth · ‎06-13-2016

Yes I did. Please note that while you change your variable to look up select box you have to change the look up value field to Sys ID and look up label field to the name of the field.

SC10 · ‎06-13-2016

I have set mine up as follows but it is still not working:

http://puu.sh/prkAh/af7ec62370.png

sidarth · ‎06-13-2016

please change the other variables look up value field to Sys ID too