Changing the Card Color in Active board

Question

Hi Guys..

Need some help

In my JIRA ticket I have a field called Reviewers.

I am looking for a JQL for changing the card color in the Sprint Board Settings as per the number of users added in the Reviewers field

Condition for JQL:

If 3 users are added in the Reviewers field, the card color should be Red

If 2 users added in the Reviewers field, the card color should be Blue

If 1 user added in the Reviewers field, the card color should be Green

If no user in the reviewers field, then no card color.

Is this possible to achieve via JQL or any other way?

John Funk · Answer

Hi @usman_malik  - Did the responses answer your question?

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

You can't do this with JQL alone, it doesn't count things.  You can script something to enable it though - what you need is a custom field with "reviewer count" in it, so your script should trigger on issue edit, look at the reviewers field and put the count into the field.

Then your JQL for card colours would be "reviewer count = 1", "reviewer count = 2" and "reviewer count > 2"

Dave Mathijs · Answer

Hi @usman_malik welcome to the Atlassian Community!

Although I don't think you can achieve your requirement without scripting, you can add the Reviewers to your card if that helps.