Dashboard Filter for multiple status

[Dave Eade]

Hi, I have a Porject with 1,000 of issues - there are about 25 different "status" which can be used.

How do I construct a filter using JQL that detects multiple status - I've used this below but it doesn't work - any help greatly appreciated!

issuetype = task AND project = "New Project" AND status = "backlog" or "In Progress"

[Kristine Weiß · Accepted solution]

Hi Dave, 

if you want to use the operator =, then you can try this:

issuetype = task AND project = "New Project" AND ( status = "backlog" or status = "In Progress" )

Another option is

issuetype = task AND project = "New Project" AND status IN ("backlog", "In Progress")

Since you mentioned that you have plenty of status, the second option is probably the better one.

Best regards, Kristine

[Dave Eade]

Many Thanks - if I wanted to exclude status' - would the syntax be NOT IN?

Thanks

Dave

[Laurie Sciutti · Accepted solution]

Hi @Dave Eade ~ you may also be able to use statusCategory, which allows you to pull (or exclude) any of the 3 status categories (To Do, In Progress, Done).  This is especially helpful when you want to search based on Open (To Do, In Progress) or Closed (Done).  HTH

Ref:  https://confluence.atlassian.com/jirakb/how-to-search-using-statuscategory-statuscategorychangeddate-function-with-jql-1115669437.html