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.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG