Reference Qualifier issues

[jonathangilbert]

Hi All

Can someone help me with a reference qualifier on a Catalog item

I have the first variable on the form called "Colleagues Store Location", which is referencing the location table.

I want the 2nd variable called "Name of colleague" which references a custom table called "employee data". This table also includes a field called u_location, which references the location table.

What I am trying to do is for the 2nd variable to only display the employees that have the same location on their employee record (u_location) that has been selected in the first variable

So for example, if the Colleagues Store Location is set as "Birmingham", I only want the 2nd variable "Name of Colleague" to only display users that have "Birmingham" as the location on the their record

This is what I had as the ref qualifier on the 2nd variable, but it just displays everything 

u_location=javascript:current.variables.colleagues_store_location

[jency83]

Try this

javascript: 'u_location=' + current.variables.colleagues_store_location;

[RakeshM49470519]

Hi @jonathangilbert ,
Use advance reference and give reference qualifier as
javascript: 'u_location=' + current.variables.colleagues_store_location


Regards
Rakesh

[RakeshM49470519 · Accepted solution]

Hi @jonathangilbert ,
Use advance reference and give reference qualifier as

javascript: 'u_location=' + current.variables.colleagues_store_location

Regards
Rakesh

[Tanushree Maiti]

Hi @jonathangilbert 

Use this -

Adv Ref Qual:

javascript: 'u_location=' + current.variables.colleagues_store_location;