How to color a card based on if it has subtasks of a certain status.

[JT Bruch]

I've been struggling with what I think should be a simple task.  Color a card based upon if it has subtasks of a certain status.

I have tried a whole host of various Googling/Stack Overflow/Atlassian Answers and have yet to figure this out.  Any help would be much appreciated.   

These are some of the attempts that have failed:

• issuetype = "Story" and issueFunction not in hasSubtasks()
• issue in issuesWithRemoteLinksByGlobalId("SubTaskId")
• issueFunction in subtasksOf("status = COMPLETED")
• parent = issuekey

This is likely a simple issue but I'm new to JIRA administration and help would be much appreciated.

[Ignacio Pulgar]

There's no such a built-in function that returns all issues that have at least one subtask. So, issues that have any subtasks under certain statuses doesn't exist either.

You may achieve it with a third party plugin, though . 

[Ignacio Pulgar]

Look for Script Runner for JIRA Cloud in the Atlassian Marketplace.

[JT Bruch]

Is there functionality to determine if an issue has subtasks at all? 

[Aylin Kohls]

Hi JT

I believe is not possible with raw Jira, but I use an addon (JQL tricks plugin) that has a special function you can apply to issue field (issue in subtaskIssuesFromFilter(savedFilterId)) 

Good luck!