Multiple status in JQL

Raymart Cruz

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

 

Rudy Holtkamp

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