Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,275 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