'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