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

[suzipearson]

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 list

thanks

Suzi

[VigneshMC]

Right click over the variable name, and click on configure variable.

And then go to Reference qual condition under type specification and add your filter

[suzipearson]

Hi Vignesh

thanks for replying

If I do that I only get this view. I tried configuring form layout - to add ref qual condition but they were already there. so I assume its something specific to a lookup select box

[VigneshMC]

add in reference qual box like 

u_hidden=false

[Kristin S_ M_ · 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.