Query for all issues with more than one component

Question

Need a Jira Query for all issues which have more than one component.

Each EPIC has a list of components that it effects. I want to query for all issues with two or more components listed. These will need to be discussed across teams, hence the interest in them.

Naveen Pendly · Answer

@DPKJ We have more than 100 components in project, we required query for all issues with more than one component

Thanks,

Naveen

DPKJ · Answer

@Ravi Dandunumber/count query as parameter is currently not possible in stock JQL provide by Jira.

If you have limited number of component, you can use `AND` to find issue which has more than one component.

Let us say you have 4 components, 'A', 'B', 'C' and 'D'. you can write query like this to find issues which has component A and one or more other component,

component = "A" AND component IN ("B", "C", "D")

After this it will an overhead on you to merge list of issues. You can use excel export to do this.

Moreover, you can look into various JQL extension plugins in marketplace, like "JQL Tricks", "JQL Search Extension" and "ScriptRunner" etc.