Colour coding tickets based on Fix Version

[Shak]

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:

Any help would be greatly appreciated. 

[Trudy Claspill]

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()")

...is valid JQL natively, but perhaps if you have added third party apps to extend the JQL capabilities it might be valid for your instance.