Include subtasks in JQL query for Slack integration

[Austin Lo]

Hi all--

Trying to set up slack integration-- 

Want to send all updates for issues labeled "foo" , but also include updates on subtasks where the parent Story is labeled "foo"-- doesnt really matter how it behaves if the subtask itself has a label. 

In the query, I can put in "labels = foo" to get all the issues labeled "foo"--but what I really want is something like "labels = foo OR parentIn (labels=foo)

Is there a way to do this?

[Jack Nolddor _Sweet Bananas_]

Hi Austin_Lo,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Query for issues having a given label and their subtasks

labels = foo OR issue IN subtasksOf(' labels = foo ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

[Luiz Silva]

FWIW it does not work with Jira Cloud.

[Jack Nolddor _Sweet Bananas_]

You're right, my mistake.

I didn't notice the user was on Cloud T__T

[Luiz Silva]

Hi!

Unfortunately, such JQL (accessing parent or child attributes) is not supported in Jira Cloud.

An alternative solution could be achieved using Jira automation. You could, for instance, create a rule that labels child issues according to the parent. There's a blog post explaining this idea in more details here. 

Hope that helps.

Cheers!