Reference Qualifier for variable set variable

JU
Kilo Contributor

Good evening all,

I am trying to get a reference variable in a variable set to only show the list of users that correspond with the titled selected.

So if 'Solution Consultant' is selected, only users with the title 'Solution Consultant would show up.

Note:

The Position field on the cat item (role) is a reference on the 'r_role table
The Preferred Dev field on the cat item (p_dev) is a reference on the 'u_devs' table

The table u_dev has a reference to the r_role table, via the u_title field on the u_dev table.

I've tried using the script include below , but im sure its wrong.

javascript: 'title=' + current.variables.role;

 

Any help would be greatly appreciated.

 

find_real_file.png

7 REPLIES 7

Hello JU,

Considering this, you should write your reference qualifier in the following way:

javascript:"u_user_record.active=true^u_title=" + current.variables.role


If this is not working, try to hardcode a position to see if it works:

javascript:"u_user_record.active=true^u_title=Senior Developer"


Hope this solves your issue!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

JU
Kilo Contributor

So hardcoding the position works, but i still have to figure out a solution for the other titles, any idea why hardcoding the value is working?

JU
Kilo Contributor

This is what finally worked:

javascript:'u_user_record.active=true^u_title=' + current.variables.role.getDisplayValue();