Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple status in JQL

Raymart Cruz
Contributor
June 10, 2024

How can I create a JQL query to search for multiple statuses in one project?

Here are the sample statuses I want to search using JQL:

  • Awaiting for Approval
  • Waiting for approval
  • Waiting for Approval from Tool Owners

Here’s the sample JQL I created, but I received an error:

"Group[Dropdown]" = "SME" AND status NOT IN (Awaiting for Approval, "Waiting for approval", "Waiting for Approval from Tool Owners") AND project = TIN

 

Screenshot 2024-06-10 at 9.14.14 PM.png

1 answer

1 accepted

2 votes
Answer accepted
Rudy Holtkamp
Community Champion
June 10, 2024

hi @Raymart Cruz ,

You are almost there, just don't use spaces in statuses without quotes:

This should do it for you:

"Group[Dropdown]" = "SME" AND status NOT IN ("Awaiting for Approval", "Waiting for approval", "Waiting for Approval from Tool Owners") AND project = TIN

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events