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 the Done column by maximum date

Elisabeth Norberg

My filter query currently looks like this:

project = MYPROJECT AND issuetype in (Story, Task) ORDER BY updated DESC

I would like to add in that any cards with the resolution 'Done' that are older than 35 days should not be visible. Unresolved cards older than that should remain.

Could someone help me figure out the correct query? Many thanks in advance

Accepted answers

All comments

John Funk

Hi Elisabeth - Welcome to the Atlassian Community!

Give this a try:

project = MYPROJECT AND issuetype in (Story, Task) and status changed to Done AFTER startOfDay(-35) ORDER BY updated DESC

Elisabeth Norberg

Hi @John Funk ,

Thanks for helping! Unfortunately that results in ONLY seeing cards that have been marked as Done in the last 35 days, not any of the on-going issues.

Basically, if an issue is NOT resolution = Done, it should be visible forever. If an issue has resolution = Done, it should only be visible for 35 days.

The end result should be that my "Done" column gets a bit smaller.

John Funk

Okay, let's try this one then :-)

project = JIRA AND issuetype in (Story, Task) and (status != Done or status changed to Done AFTER startOfDay(-35)) ORDER BY updated DESC

Elisabeth Norberg

Thanks a lot!

I tried changing "status" to "resolution", but it gave very different results - oddly enough. How would you do it for resolution?

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software