User table email address filtering.

Annie10
Tera Contributor

‎09-20-2023 09:49 AM

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

 

 

 

0 Helpfuls
  • 804 Views
18 REPLIES 18

Sandeep Rajput
Tera Patron
Tera Patron

‎09-20-2023 11:34 AM

@Annie10 Does your sys_user table have multiple records for the same user with different email ids? Or their single user record has multiple associated email ids?

0 Helpfuls

Annie10
Tera Contributor
In response to Sandeep Rajput

‎09-20-2023 12:59 PM

Hi @Sandeep Rajput 

Single user record has multiple associated email ids.

0 Helpfuls

Danish Bhairag2
Tera Sage
Tera Sage

‎09-20-2023 11:42 AM

Hi @Annie10 ,

 

You can use a simple filter condition on the reference field type wherever user table is referenced to such as :

Email contains @example.com 

 

Or advanced filter with query

emailLIKE@example.com

 

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

 

Regards,

Danish

0 Helpfuls

Annie10
Tera Contributor
In response to Danish Bhairag2

‎09-20-2023 01:01 PM

Hi @Danish Bhairag2 

Your suggestion to put a filter condition on the reference field type.  It solution works on individual catalog item, but will not work for all catalog items.

 

0 Helpfuls