Jira sub-filter to hide certain tasks older than 1 day

Question

Hi

I have introduced the below sub-filter to my Kanban board to do the following

* Show all tickets that are not resolved.
* Hide resolved tasks older than 1 day where given labels are present
* Hide resolved tasks older than 7 days where given labels are not present

resolved is EMPTY OR labels in (Label_1, Label_2) AND resolved >= -1d OR labels not in (Label_1, Label_2) AND resolved >= -7d

The issue I am experiencing is that I have found some tickets that are being hidden where they have been resolved within the last 7 days with no labels present.

How can I modify the above sub-filter to yield the above requirements?

Thank you.

Paul · Answer

Thanks @Jack Brickey

Please see the below screenshots

Primary Filter

Sub-filter

JQL Query showing story and field values

Lifecycle of ticket affected ticket

Bill Sheboy · Answer

Yes, and...I recall the Kanban sub-filter removes all parentheses, so the query must be written in a way to ensure its Boolean order of precedence matches what is needed for the results.

I recommend writing the query stand-alone in the all-issues search first, creating it step by step without parentheses (except for any IN / NOT IN checks) to confirm it works as expected.  Then use it with the board.

And a work-around for the resolution changing problem may be to use statusCategory and statusCategoryChangedDate fields.

Jack Brickey · Answer

So I assume that the culprit is moved from done to some 'not-done' status which results in the resolution being cleared along with the resolved date. Then if it is moved to Done again the resolution and resolved date are set. I need to see the details of this issue to understand how it is filtered based on the current filter.

please share the current filters you have (primary and sub filters) and the labels and resolved date. Screenshots are best