Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

how to Find duplicate user email in Users table List?

Allu Gopal
Kilo Expert

Hi,

I want to see the duplicate email users in the list view of User Table without using of show matching. Help me in this.find_real_file.png

 

2 ACCEPTED SOLUTIONS

Hi,

please use [IS ONE OF] operator

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

Hi,

it worked well

For multiple emails use [IS ONE OF] operator

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

23 REPLIES 23

Jaspal Singh
Mega Patron
Mega Patron

Hi Allu,

 

Can you do below.

Change the line 4 duplicateEmail: function to duplicateEmailis: function

Call it in the filter as below

Email | is one of | javascript: new duplicateEmail().duplicateEmailis()

Hi Jaspal Singh,

It is working Thank you but it working only for one duplicate email.find_real_file.png

but it is not working for more than one duplicate records.

find_real_file.png

Hi,

please use [IS ONE OF] operator

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Strange. 

Can you confirm the exact filter & script include you using.