Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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