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

Go to solution
Sachin G K1
Kilo Sage

‎05-27-2022 01:47 AM

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

0 Helpfuls
  • 1,046 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎05-27-2022 01:55 AM

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

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to Sachin G K1

‎05-27-2022 02:37 AM

Hi,

why select box?

If there are lakhs of users then will the end user scroll for so many choices

Inform the customer that this is not a valid requirement and you need to use Reference or Lookup select box

Not all requirements are meant to be implemented as it is.

Regards
Ankur

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