JQL to check if issue contains subissues with a certain status

[Tim Franken]

NOTE: We have JIRA On Demand so we can't install plugins.

I'd like to give issues a certain cardcolor using the query option. Our issues that are On hold get a red color.

Now I'd like to give issues a certain color, which have subissues in with a certain status. Unfortunately, this does not seem possible with the current JQL options.

I tried for instance: issuetype in standardIssueTypes(issuetype in subTaskIssueTypes() and status="Dev testing") but this does not work.

Any ideas or is this not possible in On Demand?

[JamieA]

It's not possible without plugins...

With plugins it's easy, eg

issueFunction in parentsOf('project = JRA and status = "Dev testing"')

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-parentsOf(Subquery)