Filter records that have multiple values in Custom field

[Barbara Johnson]

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 ?

[Marianne Miller]

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.

[Muhammad Ramzan(Atlassian Certified Master)]

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)

• Create a Calculated field
• Field type will be number
• Get the custom field inside your script and split it using ","
• Return the count 

Now inside your JQL query , you can fetch results with this field 

[Kunal Godbole]

I have a similar requirement. Is there a custom JQL function to do this in Jira directly? 

[Vladimir]

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.