JQL on KanBan board subfilter to hide only "done, older than 3 weeks"

[Deleted user]

Hi guys,

as we have a special case I was looking for an option to change the option "Hide completed issues older than" manually into 3 weeks.

All done items that are longer resolved than 3 weeks and are in the done column should be hidden from the Board. I tried some different logics, but could not show it correctly. I also tried some combinations of the below shown JQL.

This were my ideas.

(resolutionDate is not empty and resolutiondate > -3w) and status in (Done)

(fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND NOT resolutiondate < -3w

(fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND NOT (resolutionDate is NOT EMPTY AND resolutiondate < -3w)

(fixVersion in unreleasedVersions() OR fixVersion is EMPTY) AND NOT (resolved < -3w)

fixVersion in unreleasedVersions() OR fixVersion is EMPTY OR project = AO AND type = Sub-task AND NOT status = done AND resolved < -3w

Can someone help me to achieve this?

Thanks, Jaro

[Bill Sheboy · Accepted solution]

Hi @[deleted] -- Welcome to the Atlassian Community!

Just to be clear, you want to update the display of issues on the board, and not the reporting, correct?

And, are you using versions consistently to manage work?

Kind regards,
Bill

[Deleted user]

Hi @Bill Sheboy thanks for the questions. I want to update the display, correct.

I am not sure if the entire company is using versions consistently, but we do on the board I work on.

My main problem is to hide the the older done tickets. Once I get this working, I will not get displayed all "not done" tickets.

Thanks

Jaro

[Bill Sheboy]

Perhaps try simplifying your sub-filter to just use resolved, such as:

resolved IS EMPTY OR resolved >= -3w

[Deleted user]

@Bill Sheboythats was somehow to easy and to obvious. I feel a bit stupid for not trying this in the first place. It did the trick.

Thank you very much.

[Bill Sheboy]

I am glad to learn that helped, and...

JQL is not a SQL and so it is not always obvious what will/will not work with Jira (especially given some defects for EMPTY handling in JQL due to the recent "improvements" :^)

[Marta Woźniak-Semeniuk]

Hey @[deleted] 

Maybe try 

fixVersion in unreleasedVersions() OR (status = Done AND resolved < -3w)

 Alternatively

fixVersion in unreleasedVersions() OR (status = Done AND resolutiondate < -3w)

[Deleted user]

Hi @Marta Woźniak-Semeniuk,

I have to add this part with the "fixVersion" because something is in use somewhere else:

fixVersion in unreleasedVersions() OR fixVersion is EMPTY OR status = Done AND resolutiondate < -3w

both will not filter out any done things and shows them (arround 330) all in the done column.