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

[Shirra Arden]

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?

[Marc - Devoteam]

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]

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

[Marc - Devoteam]

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]

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 - Devoteam]

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