Roadmap JQL: Show all childissues

Question

Hello,

I need help with a JQL query.
I want to view all child issues of a roadmap project. Unfortunately, so far I only have query to display child issues of single tasks e.g.
issuekey in portfolioChildIssuesOf("LR-597")
However, this query only shows me the child issues of task LR-597. However, I want to display all child issues of all tasks.
Does anyone have an idea?

Translated with www.DeepL.com/Translator (free version)

Tony Langlet · Answer

Hello @Negjat Jusaj 
I don't think there is a way to get a structured filter for the issues and their child issues with just the filter function.

There is Plans (Advanced Roadmap) function in Jira, but it's part of the Jira Software Premium and Enterprise.

https://www.atlassian.com/software/jira/guides/advanced-roadmaps/overview#what-are-advanced-roadmaps

If you're using the Epic issue type with Task issue types, you can do this to capture all tasks and epics.

(issuetype = Epic or (issuetype = Task and "Epic Link" is not EMPTY))

I hope you could use some of the information.

mauricio.groth · Answer

Hi @Negjat Jusaj

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your children of your tasks.

issue in childrenOfIssuesInQueryRecursive("type = task")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

Mikael Sandberg · Answer

Out-of-the-box JQL does not allow you to do nested queries that is required to get parents and all their child issues. You would need an app like Scriptrunner/Enhanced search  or JQL Tricks which enhances JQL to allow you to do that. There are also other apps in the Marketplace that can do this.