- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2022 02:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2022 02:17 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-27-2022 02:22 AM
Hi Ankur,
I known i can use reference variable or lookup. But there is requirement to use select box.