JQL that shows all child issues for a given card

[Michael Perrin]

Hi,

i'm using Advanced Roadmaps and have created a card type that sits above Epic in the Hierarchy

what i want to do is to search all cards that are linked to that card

now i can use Parent link = XXX to generate the list of Epics and then use Epic Link in (E1, E2, E3 etc) but this is time consuming and we would need to update the query every time a new Epic is added to the project

is it possible to see all cards linked to the top level card without having to list each Epic individually?

[mauricio.groth · Accepted solution]

Hi @Michael Perrin

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, we have the function ChildrenOfIssuesInQueryRecursive for a given JQL subquery it finds issues in the hierarchy below the resulting issues up to an optional depth. It supports Advanced Roadmaps “Parent Link” and a standard Jira hierarchy Epic → Story → Subtask. For example, you can use the query below to find all epics, stories, and subtasks in initiatives in project ACME.

issue in childrenOfIssuesInQueryRecursive("project='ACME' and type=Initiative")

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

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

[Michael Perrin]

thansk both for responding.

i thought as much but wanted to check. we'll probably reconfigure the cards to make it easier to manage the JQL rather than adding an additional step

[Marco Brundel · Accepted solution]

Hi @Michael Perrin ,

I think with the basics of Jira's JQL it is not possible.

But when you have the app Scriptrunner you can use 

linkedIssuesOfRecursive

See here for the scriptrunner documentation.

Regards, Marco