'How to make a JQL query for issues with multiple components
I'd like to query all issues in JIRA that are associated with more than 1 component. Is that feasible in JQL, and how?
Solution 1:[1]
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.
Solution 2:[2]
component in ("component 1", "component 2", "component 3") ORDER BY updated DESC
Above solution helped me :)
Solution 3:[3]
Something like this should work:
components in (mycomponent1, "my component 2")
More help available at the Syntax Help icon on the advanced searching page
Solution 4:[4]
You can use
component in ("Component A") and component in ("Component B")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | RomanHotsiy |
| Solution 2 | Arokia Lijas |
| Solution 3 | mdoar |
| Solution 4 | rlandster |
