I'm creating a filter, but apparently I can either see only subtasks or main tasks, but not both?

[Fernando Brandao]

Hi! :) I'm creating a filter (reports) and apparently if I get a template that contains sub tasks, there is nothing I can do to be able tosee the main task where that sub task is, or the other around is the same, if I get a template that has the main task, I can't see sub tasks in it. Am I doing something wrong?

[Mikael Sandberg · Accepted solution]

Hi @Fernando Brandao,

Welcome to Atlassian Community!

Correct, out-of-the-box JQL cannot do nested queries so that you can get the parent issue with its children, unless you specify the parent issue in your query. You would need an app from the Marketplace that extends JQL in order to do it. I have used JQL Tricks and Extended Search in the past to do this, and I know that you can do this in Structure as well.

[Prosper Agwegiokhe]

Hi @Fernando Brandao ,

I’m Prosper, a support engineer at Appfire, and I’m here to help you.

As @Mikael Sandberg as said, unfortunately natively, you’ll not be able to do get your desired result.
In the app where my team works, JQL Search Extensions for Jira, you can use this query to find the main task and the children of task in question:

issue in childrenOfEpicsInQuery("key = '{mainTaskKey}'") Or key = '{mainTaskKey}'

Please contact our support if you have any other questions about this query.
We’ll be happy to help you!

Best regards,
Prosper.

[Dexter de Vera]

Hi @Fernando Brandao ,

Welcome to the Atlassian community.

Sorry, I'm confused about your question. Can you show us the screenshot of the created filter with JQL. Are you trying to filter all subtasks and main tasks? what kind of report are you using?

Thanks!

.