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; } } }

Removing a status from a filter

Lisa Stewart_42gmqn

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)

Accepted answers

Rilwan Ahmed

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)

All comments

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)

Rilwan Ahmed

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

Lisa Stewart_42gmqn

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

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