Reference Qualifier on a User Reference Field(on sys_user table) to show only active users in servicenow

[Vaishnavi35]

Hi,

Reference Qualifier on a User Reference Field(on sys_user table) to show only active users in servicenow.

I have to have users who are only active rightnow. In Reference qual field i want to right the script...

Please help me with this.

Thanks,

Vaishnavi

[p t1]

Hi,

Use this encoded query  in your reference qualifier..

active=true

Thanks,

Preethi

Please mark correct, if helpful.

Thanks,

Preethi

[Ankur Bawiskar]

Hi Vaishnavi,

by default there is out of the box business rule on sys_user table which shows only active users

BR Name: user_query

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Nikhil Phalke · Accepted solution]

Hi,

In reference qualifier just write the below script.

javascript:"active=true"

Mark Helpful & Correct.

Regards

Nikhil Phalke