JQL to identify the same values in a numbers field (without searching for a specific value)

[Adrienne McCoy]

Hello,

I am wondering if it is possible to utilize JQL to identify the same values in a custom field within the same project? It would be a text field with numbers as values, therefore I cannot search for specific values directly because I have thousands of numbers. I am looking for duplicates within the same project.

To provide an example, in project XYZ, I want to run a JQL where ANY values match in customfield1.

Value 1234 is in customfield1 on ticket XYZ-1.

Value 1234 is also in customfield1 on ticket XYZ-2 and XYZ-3.

I want to return all 3 tickets in my JQL, as well as any other tickets where the values are matching/duplicated.

If it helps, I have ScriptRunner if that needs to be the solution.

[Jack Brickey · Accepted solution]

You can certainly find all issues where a custom field has a certain “known” value…

project = XYZ and customfield = 1234

But I expect your goal may be more complex than this? Maybe you are looking to find all issues where a custom field value occurs more than once in a project? You could sort by the custom field allowing observation of duos. Otherwise, if this isn’t a frequent action the exporting to excel would be an option.

[Adrienne McCoy]

Thanks Jack! Yes, I'm looking to find all issues where a custom field value occurs more than once.

Excel is likely what I will end up utilizing.