Validating Shown Reference Options From Other Reference Field

[Wasdom_Kung]

Hello,

I have an item with two fields:
Manager - references the sys_user table

Requested items - references the requested items table and limits to a specific type of requested item

I want to have the requested items reference field only show requested items requested/opened by the manager name in the reference field above, so that it would filter out requests of the same type by other managers.

What would be the best way to achieve this? 

[Vishal Birajdar]

Hi @Wasdom_Kung 

You can write advanced reference qualifier on Requested item variable like below :

javascript:"opened_by="+ current.variables.manager;   // Manager variable backend name

[Wasdom_Kung]

Hello,

I've tried both your solution and Jaspal's but both just displayed all requested items that have been logged since the beginning of time

[Jaspal Singh]

Hi,

Considering Opened by will be set as Manager you can try below.

javascript:'opened_by='+ current.variables.manager+'^cat_item=abc';
// replace abc with catalog item name that you have filterd already and manager with backend manager variable name

[Wasdom_Kung]

Hello,

I've tried both your solution and Vishal's but both just displayed all requested items that have been logged since the beginning of time