nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to exclude a status from a filter

Lisa Stewart_42gmqn

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

Accepted answers

John Funk

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

All comments

John Funk

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_42gmqn

Hi John,

Thank you so much!! That worked perfectly!!

Thanks,

Lisa

Lisa Stewart_42gmqn

Hi John,

Thank you so much!! That worked perfectly!!

Thanks,

Lisa

Lisa Stewart_42gmqn

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)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

sql

jira-software

jira-software-server