JQL Query containing multiple Projects and multiple assignees

[Trisha_Colotto]

Hello, 

1. 3 projects - we will call them P1, P2, and P3

2. Around 10 assignees A1.......

3. I want No Done or Cancelled issues in the counting of issues.

The first part, Query for Projects, no done or canceled works fine as follows.

(project = "P1" OR project = "P2" OR project = "P3") AND resolution = Unresolved AND status != Done AND status != Cancelled

when I continue to add -  AND assignee = A1 OR assignee = A2, etc... it grabs the assignees, but it includes other projects and some done or canceled - and this is where I am stuck...any ideas, please :-)

[Vikrant Yadav · Accepted solution]

Hi @Trisha_Colotto  Welcome to Atlassian Community!

Kindly modify your JQL query like below :- 

project in ("A","B","C") AND assignee in ("a","b","c","d","e") AND status not in ("Done","Cancelled") AND resolution = Unresolved

Kindly check Document for more info :- https://www.atlassian.com/software/jira/guides/expand-jira/jql#advanced-search

Thanks

V.Y

[Trisha_Colotto]

Thank you so much - nowhere in the JQL Support documentation was it possible to find the grouping as you have provided - and it has opened up a more precise understanding now, muchly appreciated :-)

[Vikrant Yadav]

Thanks @Trisha_Colotto 😊