Usage of Refernce qualifier

[Ramesh01]

How can i make reference field to show an exhaustive list of users instead of all the users when given sys_user table as reference,

[Ramesh01]

Hi @manjusha_ 
my condition is  has to show the users who are having a particular designation.

[manjusha_]

@Ramesh01 

do you have designation field on catalog form?

if yes, you can use that field in advanced reference qualifier as below

javascript: "u_user_designation="+current.designation;

current.designation---catalog variable

u_user_designation--this is field on user table

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact

Thanks,

Thanks,

Manjusha Bangale