RAG Status Coding

[Keith Shipman]

Hi everyone I'm after a bit of help if possible.

I'm trying to write a code using JQL to find any Story issue types that have a green "RAG Status" but a Sub-task on the Story has a red "RAG Status"

It feels like it should be a fairly simple one but I just can't seem to get the coding right

[Nikola Perisic · Accepted solution]

Hello @Keith Shipman 

Could you elaborate more about these green and red statuses? In Jira, statuses can be grey (To Do), blue (In progress), green (Done). Is the RAG-Status a label instead?

[Keith Shipman]

Hi Nikola thanks for replying.

The RAG status' we use are in the "Details" side of the card and are a drop down option when you click into it.

This is what it looks like if that helps:


For us Green is on track, Amber is slightly off track and Red would be seriously off track and causing a considerable risk. We'd also use Blue for Completed/Delivered

[Nikola Perisic]

So this is actually a drop down custom field and you want to have these options to be colored. I'd recommend Awesome Custom Fields app from Atlassian marketplace. Jira doesn't have the functionality to add the colored dropdown custom fields.

[Keith Shipman]

Ah sorry Nikola I'm not sure if I managed to explain it correctly.

The colours are fine, I'm looking for some help with the coding to identify any Story issue types that have a Green RAG status on the card but a linked Sub Task has a Red RAG status