You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I would like to change a card's colour if a field changes as follows
sprint <> planned sprint
so if the item's sprint changes from that it was originally planned for, then the colour of the ticket will change
I don't think JQL allows you to set a cards colour in the board config by comparing two fields e.g. Desired for Delivery in Sprint / Iteration No <> Planned for Delivery in Sprint / Iteration No
Hi @Mike Wilkins -- Welcome to the Atlassian Community!
Where are you getting information about the "planned sprint"? Is that a custom field your team has added?
Next, you are correct that JQL cannot compare issue fields. (It is not a SQL, and so does not have such features.)
If you have any marketplace addons for JQL, they may support such comparisons.
If you do not have such addons, a work-around could be to use an automation rule to detect the condition for the sprint mismatch, and then set a field on the issue which can be used in JQL to set issue color views. For example, add a label (or custom field) and check for that with your card color JQL in the board settings.
Thanks @Bill Sheboy I should have mentioned that they are custom fields. Your answer confirms my conclusion. However I have now been able to devise a (complex) JQL in the board configuration that meets the request.