How do I color an issue from the status of its subtasks?

[David Pettit]

I am using subtasks to indicate when a defect has been found in a particular story / task. What I want to do is use the status of those tasks to visually highlight to the testers whether a story is ready for test.

Is it possible to use a JQL query to check the status of its subtasks to set the colour of the parent? 

[Robert Leitch [ALM Works]]

Hi David,

You won't be able to do that with bare JQL.

It may be worth taking a look at Adaptavist's Script Runner addon (just a hunch).

Our Structure addon could also help; by putting those stories/tasks in a structure with their sub-tasks underneath them, you can then use an S-JQL query (it works anywhere that JQL is accepted) to match issues that have sub-tasks in a certain status. The query would look something like:

issue IN structure(structureID, "child in [issuetype = sub-task AND status = open]")

Cheers,

Robert