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

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

[John Funk]

Just curious but why would you use Resolution instead of Done? 

If you are looking for issues that have other resolutions, which I think you are ;-)

Then try this:

project = MYPROJECT AND issuetype in (Story, Task) and (status != Done or statusCategory = Done and statusCategoryChangedDate >= startOfDay(-35)) ORDER BY updated DESC

Not sure exactly on the -35days part for that so verify your results  :-)

[Elisabeth Norberg]

It's because if an issue gets rejected, the resolution is "Done" while the status is not "Done". I want to filter such cards out after 35 days as well, e.g. Any card we won't be working with moving forward should disappear after the specified amount of time.

[John Funk]

The statusCategory part above should take care of that. Where you able to verify the results of the latest one? 

[Elisabeth Norberg]

@John Funk It doesn't seem to filter out the cards that have been rejected, as they are not given a Status category in our system.

[John Funk]

How are you denoted rejected cards? And why wouldn't you use a status for those? ;-)

[Elisabeth Norberg]

Rejected cards receive the resolution "rejected" and status "done". It's set by my organisation so unfortunately not something I have control over.

Am I right in thinking it's not possible to use resolution in this query then? That would solve all of this.

[John Funk]

statusCategory actually picks those up already. Status fall into one of 3 categories, Done, To Do, In Progress. So if the statusCategory = Done it should get the Rejected ones as well. Did you run the query to see if anything is missing?