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? 

[Jaspal Singh]

Can you kindly help share what is that being used. We are no where limiting it by state so it will show all only 'abc' item from the beginning.

[Wasdom_Kung]

Hi Jaspal, here was my attempt:
'u_select_your_manager'  - sys_user table for selecting user

'u_ritm_reference' - requested_item table for showing all ritms to be limited to manager

'u_ritm_reference' type specifications set to:

javascript:'opened_by='+ current.variables.u_select_your_manager+'^cat_item=NHS Lothian User Account Request';

Removed existing reference qualifier for testing but still shows all ritms in the table.

[Jaspal Singh]

Thanks. Try below.

javascript:'opened_by='+ current.variables.u_select_your_manager+'^cat_item.name=NHS Lothian User Account Request';

[Wasdom_Kung]

Hi Jaspal,

Still having the same outcome, as with the solution from Anand:

[Anand Kumar P]

Hi @Wasdom_Kung ,
Try below script

javascript:"opened_by=" + current.variables.u_select_your_manager + "^cat_item=cat item sys_id"

Thanks,

Anand