how to search for duplicate custom field content?

[Joel Bryant]

This question is in reference to Atlassian Documentation: Advanced searching

Is there a query to find out if there are any issues with the same value in a custom field?

Specifically i'm looking to find and eliminate duplicates when it comes to a custom field titled "Serial Number"

I could search for each serial number individually, but i'm looking for a broader search that tells me exactly what issues have matching serial number fields

[Nic Brough -Adaptavist- · Accepted solution]

I think there was an add-on that gave you a JQL function which could help with this, but I can't find it.

Natively though, no.  JQL is for finding issues "where a value = x", not "where values are the same".  The closest you can get without code/add-ons is to do a search for "custom field is not empty", then sort it by the custom field and work through the navigator display looking for where values are the same.

[Nathan Phillips]

Hello @Joel Bryant,

Thank you for reaching out on the Atlassian Community!

Unfortunately, Nic is correct that JQL does not provide a way out of the box to make this type of search comparison to find duplicated items.

If its possible, my recommendation would actually be to export these work items using a CSV Export and then using excel, to complete your comparisons for duplicates. 

[Joel Bryant]

Good Enough! now to comb through our 7,600 assets