Filter records that have multiple values in Custom field

Question

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 ?

Muhammad Ramzan_Atlassian Certified Master_ · Answer

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 · Answer

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

Vladimir_6cay7k · Answer

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.