Coloured JIRA cards to determine length of time in lane

Vishal Sharma_ylqmnt

Our team will be using colour on JIRA board to help us identify the length of time the card has been in a particular lane.  

For example Green - when card has been there 1-2 days, Yellow 3-5 days etc. 

If a tickets is flagged, we want the timer on the card to not count the time it was flagged.  Is there a way to put a query in place to do this?

Michael Yaroshefsky - Visor for Jira

Hey @Vishal Sharma - welcome to Atlassian Community. 

I think you can do this by:

1. Navigating to Jira board settings

2. Selecting "Card Colors"

3. Select "Colors based on queries"

4. Then Create new rules using JQL queries

Then, I haven't been able to test this myself but I think:

status = "Your Column Name" AND status changed to "Your Column Name" before -5d

Should be the JQL query you need, obviously modifying the "Your Column Name", and the number of days (-5d) accordingly.