Need to exclude a status from a filter

[Lisa Stewart]

I am trying to exclude Canceled from the filter below but nothing I am doing is working. Can anyone help me?

project = "XXXXXXXXX" AND issuetype = "Program Epic" AND issuekey = PFB-1437 OR issuekey = PFB-1287 OR issuekey = PFB-1286 OR issuekey = PFB-1429 OR issuekey = PFB-1432 OR issuekey = PFB-1435 OR issuekey = PFB-1613 OR issuekey = PFB-1577

[John Funk · Accepted solution]

Hi Lisa,

Try this:

project = "XXXXXXXXX" AND issuetype = "Program Epic" AND key in (PFB-1437,  PFB-1287, PFB-1286, PFB-1429, PFB-1432, PFB-1435, PFB-1613, PFB-1577) and Status != Canceled

[Lisa Stewart]

Hi John, 

Thank you so much!! That worked perfectly!! 

Thanks,

Lisa

[Lisa Stewart]

What if I have multiple statuses to remove? Like resolved, done and canceled.

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)

[John Funk]

AND status not in (Resolved, Done, Canceled)

[Lisa Stewart]

Hi John,

Thank you so much!! That worked perfectly!!

Thanks,

Lisa