Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to make a JQL query for issues with multiple components

Tags:

jira

jql

I'd like to query all issues in JIRA that are associated with more than 1 component. Is that feasible in JQL, and how?

like image 868
Antoine Avatar asked Aug 30 '11 10:08

Antoine


1 Answers

I didn't find a solution that was feasible in JQL. I also don't believe I have the ability to write JQL functions so I didn't get to explore that route.

I needed to be able to get a list of my tickets with multiple components. I did this by exporting my tickets to excel and then added a column which checked the cell in the same row in the Components column:

=IF(ISNUMBER(SEARCH(",", P5)), "Multi Components", "Single Component")

This checks the cell for the partial text ",". If it has the comma, Multi Components is returned.

like image 177
hawk8 Avatar answered Oct 16 '22 08:10

hawk8