I have a custom field Client that holds the name of the Client that has the issue.
Sometimes the same issue is reported by multiple clients, so the Client field is comma delimited with name of each the of the clients.
is there a way to query (JQL) for issues that have multiple values for the Client, such as if the count of Client >= 2 ?
Is this field a text field or string? You may be able to do it with Script (scriptrunner, but do not think there is not a JQL solution, but you may be able to build that query and export it as a CSV/Excel
in the CSV, you can split text to columns on the comma delimitation, and quickly see which have more than 1 or two.
It's not an elegant solution, but it will give you the information you need.
Might be I am late but have seen still the question is open so would like to provide my suggestion to achieve it. If you have scriptrunner you can achieve in two ways
1- Create your own JQL function (sorry I don't have example)
2- Create Scripted Field ( I have idea , please have a look)
Now inside your JQL query , you can fetch results with this field
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events