User table email address filtering.

Annie10
Tera Contributor

Hello,

Currently, there are many users in our company with multiple email address.  For example from the below screenshot. Could we filter the email address to show only ONE email address for all users?   Thanks 

 

Annie10_0-1695228397881.png

 

 

 

18 REPLIES 18

Hi @Annie10 ,

 

You can create a variable set (include other variables as well if you want as per ur need along with requested for field which are common across other catalog items), apply the filter over der & use it across multiple catalog items.

 

Please mark my response helpful & accepted if it resolves your query.

 

Thanks,

Danish

-O-
Kilo Patron
Kilo Patron

That field does already show one e-mail address for each user.

Your problem is that the same user is defined multiple times, not that a user has multiple e-mail addresses.

And the solution is to clean up the data, not to hide the mess behind some filter.

Annie10
Tera Contributor

Hi @-O- 

You are correct that the same user is defined multiple times. However, these users are required to have multiple email addresses to perform their daily tasks. FYI... Users are currently being sourced from Azure AD

 

In that case the obvious solution is a reference qualifier, of course, but from the p.o.v. of the system, those will be two (or more) separate users.

Even if their name is the same.

That means that if one filters out the "wrong" user, the correct user will not be able to access stuff meant for him, because it is registered for the "other" user (account) of his.

Unless the user can log in using any of his account, but in that case, if stuff is registered for multiple accounts of the same user, that user will have to constantly log of and back in to access the needed stuff.

 

For a precise answer, and to avoid the unpleasant situation described above. you need to specify not only that one e-mail address should be shown, but also which of the many and what is the logic of determining which is the one to include.

 

Depending on the use case, the unpleasant situation describe above could be mitigated by setting up delegation for the multiple accounts of a user - but again, more details are required to be able to tell.

Annie10
Tera Contributor

@-O- ,

Thank you for your input.  User records are currently sync from Azure AD. This step was done by a consultant and they are no longer with the company and I don't understand how it works. Do you familiar with how SN sync with Azure AD.  The reason why I'm asking is maybe we could filter it using Transform Map before importing the data into SN.