Identify duplicate emails in a glide_list field referencing to sys_user

[Jerome MAISETTI]

Hello 
I have a list of duplicate emails in my database. 
I have a field called 'u_cab' in the ast_service table which is a reference to the sys_user table, and list field type. 
I would like to report to see if any of the users present in that field have their email in duplicate in the list I get. 
Does anyone knows how I can achieve that ? I tried with a dynamic filter but no luck... 
Thanks
Jérôme

[Robbie]

Hi @Jerome MAISETTI,

A neat little trick which isn't documented too well is the ability to add a sort by based on the count in the list view.

To see where you have users that have duplicate emails, avigate to the sys_user table and group by the email column. Once the list is displayed, append the following string to the end of the URL which will then display the list in descending order based on the count:

&sysparm_group_sort=COUNTDESC

It's really handy and something I use quite often.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie