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.

FIlter out certain user accounts (they have the hidden field ticked) on a lookup select box to the sys_user table

suzipearson
Tera Contributor

Hi

Out sys_user table is populated from AD , however there are a lot of system accounts.

I want to hide these as I am creating a lookup select box available on the service catalogue for managers to select a user and automatically have their accounts in AD extended (this I can do in orchestration and powershell).

The problem I am having is that even though I put a tick next to hidden (a field on the user form) the system accounts are still showing. It used to work - any suggestion how I can filter these out?

have shown a demo with test user I have marked as hidden but they still show in the lookup listfind_real_file.pngfind_real_file.png

 

thanks

Suzi

1 ACCEPTED SOLUTION

To get help making a reference qualifier for this, you could go to the sys_user table, filter as required, right-click on filter and choose "copy query". Then paste in the reference qualifier field. 

View solution in original post

6 REPLIES 6

suzipearson
Tera Contributor

I ended up changing it to a reference instead of lookup and entered in the qualify conditions, I changed it back to a lookup box and it kept this in the reference qual

u_hidden=false^active=true^EQ

 

happy days.

many thanks for your help and time

suzipearson
Tera Contributor

thanks Kristin, I forgot that little gem