Advanced Reference qualifier on variables

[leachy23]

Hi all, 

Im currently struggling with a reference qualifier on a catalog item and wondering if anyone can help. 

I have two variables

1. application_name - a reference to cmdb_ci_appl table 
2. ad_group_reference - a reference to a custom table u_application_ad_group_reference this table contains a list of AD groups, each group record has a reference to the corresponding application from the cmdb_ci_appl table

Im trying to add a reference qualifier to the AD Group Reference variable so it only shows group records with a matching application as selected in variable 1

I've fairly new to the world of variable advanced ref qualifiers but my current version is;

Javascript;'u_application='+current.variables.application_name;

Any assistance is appreciated! 

[aashishdasari]

Hi,

Based on the below article:

https://community.servicenow.com/community?id=community_question&sys_id=3b7dcfe9db9cdbc01dcaf3231f96...

The Reference qualifier needs to set as:

javascript:'u_application=' + current.application_name;

[siva_]

Hello Leachy, 

It seems that you are using semi colon (;) instead of colon (:) and more over make sure , you have used the table to refer as your custom table in the dictionary entry of the variable 

For initial Purpose you can even  hard code an encoded query directly and check if that works for you.

Hope That Helps 

Mark this response as correct if that really helps so that this can be removed from unanswered category

Thanks,

Siva