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

Question

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.

Stefan_Bertram · Answer

Hi @ all,

I use the following command to color a card if it has subtasks:

issueLinkType = "is parent task of"

You might combine it with any other command to further specify your request.

Best regards, Birdy

Aylin Kohls · Answer

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!

JT Bruch · Answer

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