Different colors cards depend on XX days unchanged status

Question

Hi everyone,

I want to use color cards in order to give me some informations.

- 3d status no changed

!(status changed DURING (startOfDay(-3),endOfDay())) AND status not in ( "To do", "Done","In Progress.")

Same for 7 days and 15 days

But this configuration doesn't work. It shows only 2 colors but not the third.

Can somoene help me plz

BR

Clement PASSEVANT · Answer

Hi @Ste Wright

TY for your quick answer, i'll test it right now and i coming back to you.

I've found that with these 2 queries the colors is nicely override

!(status changed DURING (startOfDay(-15d),endOfDay())) AND status not in ( "To do", "Done","In Progress.")

!(status changed DURING (startOfDay(-4d),endOfDay())) AND status not in ( "To do", "Done","In Progress.")

So, i wonder why it doesn't work with others

Ste Wright · Answer

Hi @Clement PASSEVANT

I'd check in all instances (via issue search) there is data for all each JQL query - it will only colour cards which meet the JQL parameters.

----------------

For the JQL - how are you formatting this?

If you're setting colours based on:

* Issues that have not changed status in 3 days
* Issues that have not changed status in 7 days
* Issues that have not changed status in 15 days

^ There will be issues that fit into all 3 of those colours, so only one will be applied to the issue. That might be the same colour for all 3 types of issues.

----------------

You'd need to consider rules which create unique values - such as:

Issue has changed status 4-6 days ago, but not in the last 3 days:

status changed DURING (startOfDay(-6), endOfDay(-4)) AND NOT status changed DURING (startOfDay(-3), endOfDay())

...or Issue has changed status 8-14 days ago, but not in the last 7 days:

status changed DURING (startOfDay(-14), endOfDay(-8)) AND NOT status changed DURING (startOfDay(-7), endOfDay())

...and then for no status change in 15 days:

NOT status changed AFTER startOfDay(-15) AND createdDate <= -15d

^ These are more unique, covering the days inbetween 3, 7 and 15.

I included created date for the 15 days option, to exclude recently created issues which have had no transition.

----------------

You might want to consider including created dates in the other queries also - for example, to add to the first query all issues which were created between 4-6 days ago but have had no status transition:

status changed DURING (startOfDay(-6), endOfDay(-4)) AND NOT status changed DURING (startOfDay(-3), endOfDay()) OR createdDate >= -6d AND createdDate <= -4d AND NOT status changed

----------------

You can utilise these queries, or parts there-of, to enhance your current ones.

Does this help with your query? If there are still issues, please provide your current JQL queries for card colours, along with an explanation on how they should work and where they do not!

Ste