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; } } }

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

unknown

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

Accepted answers

Bill Sheboy

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

All comments

Marta Woźniak-Semeniuk_m044pw

Hey @[deleted]

Maybe try

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

Alternatively

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

unknown

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.

Bill Sheboy

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

unknown

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

unknown

@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.

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

jira-software-cloud

jql

kanban