I want to be able to configure cards/tickets with color coding based on these parameters

Shirra Arden March 7, 2024
I want to configure a JQL query something like this:

3point:
-over 3 days yellow
-over 5 days red
5points:
-over 5 days yellow?
-over 7 days red

 

Does anyone know how to layout the JQL query?

1 answer

0 votes
Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 7, 2024

Hi @Shirra Arden 

Welcome.

This can only be done on boards in Company Managed projects.

Go to Board settings and click on Card colours.

From the dropdown select Queries, then add your JQL for each different colour.

N.B. the order is important because it will use the first colour where the condition matches, so drag the items to reorder.

 

Shirra Arden March 7, 2024

Thanks, @Marc Koppelaar  for responding.  I am looking for the JQL query.  Can you assist with that?

Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 8, 2024

Hi @Shirra Arden 

JQL based on what, that's not clear stated based on story point value is easy

"Story Points" = 3

What do you mean with over 3 days and the other over options, over based on what condition?

Shirra Arden March 11, 2024

Based on a story point of 3 = days.  If the ticket sits and becomes day 5 then the card changes color from yellow to red.  Is this what your asking?

Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 12, 2024

Hi @Shirra Arden 

Still based on days after creation of the issue?

Then you can use a JQL's like;

created >= -3d

created >= -5d

 

created >= -6d

created >= -8d

Suggest an answer

Log in or Sign up to answer