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 

[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! 🙏

[suuriyas]

HI @Ankur Bawiskar ,

Thanks it works but by doing this even in user table we are not able to see those records right but i don't want that to happen....only in field reference to user table alone and in catalog variable reference to user table alone i don't want to show this records

[Ankur Bawiskar]

@suuriyas 

Glad to know that my script worked.

I believe I answered your original question and you can mark my above response as correct.

For your follow up question

check this link if it helps, but I believe you will go ahead and do lot of changes (add those many fields)

How to make inactive users available for selection in reference fields/variables 

Also my thoughts

-> why would someone use sys_user.LIST in native? -> You can ask your customer to train your users rather than doing lot of customization. You already customized the OOTB Query BR on User.

-> you are already restricting sys_user records from reference fields

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

[Ankur Bawiskar]

@suuriyas 

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

[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! 🙏