JQL for Card Color if Issue has SubTask of a certain type

[Stephen Herrick]

I'm trying to figure out how to write the JQL to set the card color if the Issue has a subtask that is a certain type ("Fault" in this case).  Here are some that I tried out and neither seem to work.

linkedIssue in(issueType = Fault AND status != Done)

subtasks in(issueType = Fault AND status != Done)

 Anyone get any success with something like this?

[Parvaneh Zand · Accepted solution]

Hi @Stephen Herrick ,

read this topic:

https://community.atlassian.com/t5/Answers-Developer-Questions/How-do-I-filter-for-parent-issues-having-specific-subtask-issue/qaq-p/533054

[Stephen Herrick]

That looks like it would help but that is a paid app.  I was hoping to find a solution using the built in functionality of Jira Cloud.

[Parvaneh Zand]

As much as I know there's no way to do this without a plugin. Your question needs a subquery inside the parentheses, but built in functions don't support it:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

[Stephen Herrick]

That is what I thought.  Thanks for your help.

[Daniel Turczanski - JQL Search Extensions]

Hi @Stephen Herrick ,

It's not a native solution but you can try our app JQL Search Extensions. It supports subqueries for links, subtasks and epics.