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.

[daniel_billingham · Accepted solution]

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

[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)

[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!

[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)