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.
Hi,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have a similar requirement. Is there a custom JQL function to do this in Jira directly?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Would it be possible to create custom jql function in script runner? I think this will be the best solution but I cannot find any example of any custom jql function that will be similar like this.
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.