Removing a status from a filter

[Lisa Stewart]

 I have the below filter and I need to remove multiple statues like resolved, done and canceled. How can I accomplish this?

project = "XXXXXXXXXXXX" AND issuekey = PFB-1653 OR issuekey = PFB-1658 OR issuekey = PFB-1772 OR issuekey = PFB-1655 OR issuekey = PFB-1656 OR issuekey = PFB-1657 OR issuekey = PFB-1808 OR issuekey = PFB-1256 OR issuekey = PFB-1592 OR issuekey = PFB-1604 OR issuekey in childIssuesOf(PFB-1653) OR issuekey in childIssuesOf(PFB-1658) OR issuekey in childIssuesOf(PFB-1772) OR issuekey in childIssuesOf(PFB-1655) OR issuekey in childIssuesOf(PFB-1656) OR issuekey in childIssuesOf(PFB-1657) OR issuekey in childIssuesOf(PFB-1808)

[Rilwan Ahmed · Accepted solution]

Hi Lisa,

To exclude statues like resolved, done and canceled, add condition and status not in (Resolved, Done, Canceled) at the end. Please make the use of brackets correctly.

Your JQL should look like

project = "XXXXXXXXXXXX" AND
(Issuekey in (PFB-1653, PFB-1658, PFB-1772, PFB-1655, PFB-1656, PFB-1657, PFB-1808, PFB-1256, PFB-1592, PFB-1604 )
OR issuekey in childIssuesOf(PFB-1653)
OR issuekey in childIssuesOf(PFB-1658)
OR issuekey in childIssuesOf(PFB-1772)
OR issuekey in childIssuesOf(PFB-1655)
OR issuekey in childIssuesOf(PFB-1656)
OR issuekey in childIssuesOf(PFB-1657)
OR issuekey in childIssuesOf(PFB-1808))
and status not in (Resolved, Done, Canceled)

[Lisa Stewart]

Thank you so much that worked. I am new at this and these filters were built by someone else and I am trying to fix them. 

Thanks,

Lisa

[Mark Segall]

There's a bit of excess in this query.  I would go with something like this:

Project = PFB and Key IN (PFB-1653, PFB-1658, PFB-1772, PFB-1655, PFB-1656, PFB-1657, PFB-1808, PFB-1256, PFB-1592, PFB-1604) OR (issue in childIssuesOf(PFB-1653) OR issue in childIssuesOf(PFB-1658) OR (issue in childIssuesOf(PFB-1772) OR issue in childIssuesOf(PFB-1655) OR issue in childIssuesOf(PFB-1656) OR issue in childIssuesOf(PFB-1657) OR issue in childIssuesOf(PFB-1808)) AND status NOT IN (Resolved, Done, Canceled)