JQL to return issues with more than one component field populated

Question

In a project, an issue (say a story) can have more than one component field populated. Here a component (let's say) refers to a service team. What will be JQL to return issues that have more than one component field populated?

1. Some issues have component field not populated

2. Some issues have only one component field populated e.g. A, or B or C etc.

3. Some issues have 3 component fields populated e.g. A, B and C; some issues with 2 fields populated such as B and D; some issues with 4 fields populated such as M, N, O and P

I want 3 from above in my result for the query.

Thanks

Arabinda Mishra · Answer

I would like a JQL that returns the stories that have more than one component. I am not interested in the stories that do not have any components.

Similarly a JQL that returns the stories that have more than one label

Alexander Bondarev_x6gjf3 · Answer

@Arabinda Mishra , does it help for you?

If you have questions - feel free to contact me.

Alexander Bondarev_x6gjf3 · Answer

Hi, @Arabinda Mishra !

JQL will be:

1. component is EMPTY

2. component in ( "A" ,  "B",  "C")

3. component = "A" and component = "B" and cpmponent = "C"