Users with empty mail id should not be display in all reference user field

[suuriyas]

HI Community,

I have a requirement, in all form fields (different tables like incident problem change etc) which reference to user table , all catalog variables reference to user table.

users with empty email id should not be display.

How can we achieve this instead of opening each variable or each dictionary to add reference qualifier is there a way to do it in one go or any easy and efficient way to achieve this?

And i also concern about what if t overrides 

[suuriyas]

HI @M Iftikhar ,

Thanks for replying 

Can you please elaborate on how to use query BR to achieve this?

[Ankur Bawiskar]

@suuriyas 

see the approach below I shared using existing OOTB query business rule.

[M Iftikhar]

@suuriyas,

Open this "user query" business rule and add this line: current.addNullQuery("email");

Business Rule:
Link: https://<your-instance>.service-now.com/sys_script.do?sys_id=62a7bfaf0a0a0a6500c49682bd82376a

If my response helped, please mark it as the accepted solution so others can benefit as well.

[Ankur Bawiskar]

@suuriyas 

but why users will have no email in their sys_user record?

it means data is not proper

Please discuss with your customer and perform clean up of sys_user table

Also you can update the OOTB query business rule on sys_user in case you don't wish to update the Reference qualifier

I highlighted the addition in Yellow

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@suuriyas 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✔️ and close the thread 🔒 — this helps future readers find the solution faster! 🙏