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! 

[Jace Benson · Accepted solution]

If you copy pasted, there's a few typos;

`javascript:'u_application='+current.variables.application_name;`

If you didn't, can you confirm they are references and not lookup select variables?

[leachy23]

Hi jacebenson, 

No it was written by me, they were reference variables, but my issue turned out to be with the ; instead of : 

it was staring me in the face!

Thanks for the reply

[SN_BUDDY]

Hi Jace, hoping you can help with this. I have a variable (account_capture) in a MRVS which is auto-populated onLoad. I also have a variable (site) in the MRVS which references the location table. 

depending on what account is populated in the "account_capture" variable, I should only see options in the "site" variable that relate to the captured account.

I tried to use the below in the advance ref qual but it did not work. Any guidance much appreciated

javascript:'account_capture='+current.variables.site.account;

[jmcagod]

If this is in Catalog Item form, maybe you can try

javascript:'u_application=' + application_name;