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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.