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

Filtering out completed risks

daniel.billingham

Hi All,

I am looking to build a filter that shows any outstanding risks/issues but would also show any complete (mitigated, accepted, resolved) risks/issues but only ones resolved in the last two weeks. So anything completed (mitigated, accepted, resolved) over two weeks would not show.

Have got the below so far but it seems to return the wrong responses (100's of risks from all areas). Not sure how to ask it both terms separately.

"Team[Team]" = x AND issuetype = Risk AND status IN (open, owned) OR resolved >= -2w

Any advice would be great.

Accepted answers

daniel.billingham

"Team[Team]" = x AND issuetype = Risk AND status IN (Open, Owned) OR "Team[Team]" = x and (status in (Mitigated, Accepted, Resolved) AND resolved >= -2w)

All comments

Walter Buggenhout

Hi @daniel.billingham and welcome to the Community!

Try to add parentheses to your filter when you start mixing AND and OR clauses. Try something like this:

"Team[Team]" = x AND issuetype = Risk AND
(status IN (open, owned) OR resolved >= -2w)

Hope this helps!

Anthony Morais

Hi @daniel.billingham Welcome to the Atlassian Community!

Try this:

"Team[Team]" = x AND issuetype = Risk AND status IN (Open, Owned) OR (status IN (Mitigated, Accepted, Resolved) AND resolved >= -2w)

Hope this helps!

daniel.billingham

Thanks Anthony,

What you gave me the system did not like for some reason but managed to get the below which worked. Apologies if the original ask did not explain it well enough!

"Team[Team]" = x AND issuetype = Risk AND status IN (Open, Owned) OR "Team[Team]" = x and (status in (Mitigated, Accepted, Resolved) AND resolved >= -2w)

daniel.billingham

Thanks Walter,

What you gave me the system did not like for some reason but managed to get the below which worked. Apologies if the original ask did not explain it well enough!

"Team[Team]" = x AND issuetype = Risk AND status IN (Open, Owned) OR "Team[Team]" = x and (status in (Mitigated, Accepted, Resolved) AND resolved >= -2w)

daniel.billingham

"Team[Team]" = x AND issuetype = Risk AND status IN (Open, Owned) OR "Team[Team]" = x and (status in (Mitigated, Accepted, Resolved) AND resolved >= -2w)

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud