Reference Qualifier for variable set variable

[JU]

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.

[Filipe Cruz]

Hello JU,

If table u_dev has a reference to the r_role table, via the u_title field, then your reference qualifier should look like:

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

Check if that 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]

Hello @Filipe Cruz ,

I made the small tweak, but the preferred dev field shows up blank now, with no users to pick from:

I did update the reference qualifier after my inital test with your script, to what you see below, but it show users whose title is different from the position selected on the cat item:

javascript: 'u_title=' 'u_user_record.active=true' + current.variables.role;

[Filipe Cruz]

Hi JU,

Can you go to the u_devs table, do a random filter by a specific position, copy the  query and paste it here? So we can see how the filtering is being done.

Thanks!

Filipe Cruz 

[JU]

Hi @Filipe Cruz ,

Thanks for the engagement, here is the query:

u_title=Senior Developer^u_user_record.active=true