Filter reference fields list based on another field

[Kasia5]

Hi All,

In Record producer for Incident I have two variales:

Calling user is fullfilled automatically, but I want to filter list of users in field 'Affected user'. If user from field 'Calling user' is from company ABC then in 'Affected user' field I should be able to see list of users from the same company.

How can I achieve this?

Thanks in advance for help

[Pedro Grilo1 · Accepted solution]

Hi,

You can have an advanced reference qualifier for the Affected User based on the calling user.

Something like:

javascript:"company=" + current.variables.affected_user.company

I hope it helps!

Pedro

[Kasia5]

It works, thank you! 🙂

[Serginho]

hello @Pedro Grilo1 , i have a similar case, can you please give me a hand, I have a reference variable named "business_role", table is x_scfr_jda_business_role, and i have another reference variable named "replacement_br" and brings the data from the same table x_scfr_jda_business_role, I need to exclude or filter out in the variable replacement_br only the record (1 record) that user selects in the variable business_role. What can I type in my reference qualifier ? any idea ? 

[Serginho]

Hello @Pedro Grilo1 , I got a similar question, I have a reference variable named "business_role", table is x_scfr_jda_business_role, and i have another reference variable named "replacement_br" and brings the data from the same table x_scfr_jda_business_role, I need to exclude in the variable replacement_br the record that user selects in the variable business_role. What can I type in my reference qualifier ? any idea ?