Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Colour coding tickets based on Fix Version

Shak I'm New Here Sep 18, 2022

Hi all, 

I'm trying to colour code the tickets on my Kanban board according to the following logic:

1) Change ticket colour to orange when ticket's fixVersion Start Date is 2 weeks prior to today. 

2) Change ticket colour to green when ticket's fixVersion Start Date to Release Date

3) Change ticket colour to red when ticket now() > fixVersion Release Date. 


This is the logic I've used but it doesn't seem to be working as expected:
Colour Cards.JPG

Any help would be greatly appreciated. 

1 answer

1 vote

Hello @Shak 

Welcome to the community.

You must use valid JQL statements when defining these queries. Try executing these queries in the Advanced Issue Search screen to confirm that they are valid and return the results you expect.

I don't believe that

fixversion in releasedate("after now()") valid JQL natively, but perhaps if you have added third party apps to extend the JQL capabilities it might be valid for your instance.

Suggest an answer

Log in or Sign up to answer