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

JIRA Filter for issues that haven't been updated in a while

Jeff A_b9nf8s

My team is using the Card Colours function to add highlights to cards which have not had any updates in a number of days/weeks. We had hoped to make a JQL that would add a yellow highlight to a card that hasn't been updated in 10 days and a red highlight to any issues that haven't been updated in more than 15 days. My JQL queries were as follows, however I am not getting the desired results. Can someone correct my syntax?

YELLOW: project = "project_name" AND updated >= 10d AND Status != Complete

RED: project = "project_name" AND updated >= 15d AND Status != Complete

Is there a limitation of using the "updated" attribute, like will it consider an issue updated if it has a comment added in those timeframes?

Accepted answers

Florian Bonniec

Hi @Jeff A

What is the issue ? You do not have any color or all cards are yellow ?

With this feature, order is important. It will use the first color that match the JQL so if you have Yellow first all card will be yellow because an issue that have not been updated for 15d have not been updated for 10.

Any field update, comment, link and attachment will change the update date.

Regards

All comments

Florian Bonniec

Hi @Jeff A

What is the issue ? You do not have any color or all cards are yellow ?

Any field update, comment, link and attachment will change the update date.

Regards

Florian Bonniec

@Jeff A

You should use updated <= -10d instead updated >= 10d

Jeff A_b9nf8s

Thanks for the follow-up. I did figure out that it should be <= -10d instead of what I had originally not long after I made my post.

What I am seeing now is the problem you mentioned about the order. If I have Yellow first, I only see Yellow highlights. But if I put Red first, then I see Red.

Is there a way for both of these rules to exist? Or is there a JQL to cover Issues which have not been updated for 10-14 days and a separate JQL for Issues that haven't been updated in 15 or more?

Florian Bonniec

I'm suprised that setting RED first set every card to red because an issue that has not been updated for 13 days should match only your first query (yellow)

You can play around with

updated >= -15d and updated < -10d

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server

colour