In service catalog, how to get only active users for selectbox type

Sachin G K1
Kilo Sage

Hi,

I have a Service Catalog item, for a field I have to select selectbox type, and the choice table is sys_user table. But I want to get only the active users in the list, how can I do that?

Regards,

Sachin

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

Should happen OOB since there is already a Query business rule on User table to show only active users

Is that not happening?

you can use advanced ref qualifier in that variable

javascript:'active=true';

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

Should happen OOB since there is already a Query business rule on User table to show only active users

Is that not happening?

you can use advanced ref qualifier in that variable

javascript:'active=true';

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

find_real_file.pngHi,

Advance ref qualifier field is not showing up.

 
 

Hi,

in question you mentioned select box type and reference type is sys_user?

Why to use select box and not Lookup select box OR reference variable?

you want to allow users to select users right then why not use reference variable?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

I known i can use reference variable or lookup. But there is requirement to use select box.