Ref qualifier over list

[Rosy14]

Hi,

I have a list type field over sys_user table. I want to filter it so that it will show users with same company name as logged in user . below not working.

javascript:'company='+gs.getUserID().company;

[Amit Verma · Accepted solution]

Hi @Rosy14 

Do you have the company set for the currently logged in user ? If you have recently set it up, you should logout and login again for gs.getUser().getCompanyID() to work. Refer below snips where it is working as expected for me :

Thanks & Regards

Amit Verma

[Anurag Tripathi]

Hi,

try this

javascript:'company='+gs.getUser().company;

[Rosy14]

Not working

[Anurag Tripathi]

This should work

Returns the company sys_id of the currently logged-in user

var companyID = gs.getUser().getCompanyID();

And your list field is a reference to company, so the reference qualifier should be as below

javascript:'sys_id='+gs.getUser().getCompanyID();

[Amit Verma]

Hi @Rosy14 

Update the reference qualifier as below and retry :

javascript:'company='+gs.getUser().getCompanyID() ;

Thanks & Regards

Amit Verma