Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filter records that have multiple values in Custom field

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 ?

4 answers

1 vote
Marianne Miller Community Leader Mar 02, 2020

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.

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.

0 votes

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

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 

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you