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

[suraj sengar]

@jonathangilbert - 

u_location=javascript:current.variables.colleagues_store_location

• The syntax is off.

• In catalog items, reference qualifiers need to return a query string or a function that evaluates the variable value.

• Simply pointing to current.variables doesn’t filter correctly.