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 

[Nawal Singh]

Hi @suuriyas ,

As per my experience you need to apply in each field but use dynamic one-

1. Create a Global Reference Qualifier Script Include

2. Use This Script Include as a Reference Qualifier

For any reference field or catalog variable that points to sys_user, set: (Example)

     - Reference qualifier type: Dynamic

     - Reference qualifier: javascript: new UserHasEmailReferenceQualifier().getQuery();

This will apply the same filter across all relevant fields.

If you found my response helpful, please mark it as helpful and accept it as the solution.

Thank you
Nawal Singh

[suuriyas]

HI @Nawal Singh ,

Thanks for replying 

Initially i thought the same to create a script include and added it as reference qualifier but still i have to open each and every record to update this right?

there are 100's of variables which reference to user table and many field like assigned to, openeby by, caller in different tables.

[Nawal Singh]

Hi @suuriyas ,

1. Yes there is no sort cut I believe , you need to update each fields configuration (dictionary-RQ)

2. In future discuss with your client don't allow user without filling email address

3. For existing users ask them to update there email address (if valid users) otherwise make inactive

If you found my response helpful, please mark it as helpful and accept it as the solution.

Thank you
Nawal Singh

[M Iftikhar]

Hi @suuriyas,

You can implement it using user query business rule.

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