What is the Jira query to check certain statuses of issues that are not Epic

[Zulfiqar Ali Shah Kazmi]

For my project there are non epic issues that are pending others, I want to see all those issues. I am trying the following query but it's not working:

project = "Project Name" AND issuetype != Epic AND status = Status 1, Status 2

[Walter Buggenhout · Accepted solution]

Hi @Zulfiqar Ali Shah Kazmi and welcome to the Community!

If you want to reference multiple statuses in a list, try the following instead:

project = "Project Name" AND issuetype != Epic
AND status IN ("Status 1", "Status 2")

Use IN (...) and - if your status names contain spaces - use quotes.

Hope this helps!

[Zulfiqar Ali Shah Kazmi]

Thank you so much @Walter Buggenhout

The query worked like a charm. Solved my problem. Really appreciate your help. Also, thanks for welcoming me to the community. Looking forward to learning a lot over here, and hopefully contributing too.

[pinky_reddy]

Hi @Zulfiqar Ali Shah Kazmi 

welcome to Atlassian community 

Try this one

project=“your project name” and issuetype!=epic and status in (status1,status2)

[Zulfiqar Ali Shah Kazmi]

Thank you @pinky_reddy for your answer and also for welcoming me to the community. Actually, the query that @Walter Buggenhout provided worked for me. Yours was 90% there. Apparently, we need quotation marks " " inside the parenthesis before and after typing the statuses.

Thanks again.