List issue(s) of type Episode without child issue(s)

[Rob_van_Maanenberg]

I want to create a query that lists all issues of type Episode in a certain project without any child issues registered.

Project = "X" AND type = Episode AND "no child issues registered".

Where X is an existing project.
What is the correct query for "no child issues registered"?

[Florian Bonniec · Accepted solution]

Hi @Rob_van_Maanenberg 

Are you using JIRA Cloud or Data Center, do you have apps such as Scriptrunner or JQL Tricks ?

Regards

[Rob_van_Maanenberg]

Hi @Florian Bonniec

I am not sure but I believe JIRA Cloud.
Scriptrunner or JQL Tricks do not ring a bell.

In the JIRA application, I use filters to create queries.

Regard

Rob

[Rob_van_Maanenberg]

Thanks!

[mauricio.groth]

Hi @Rob_van_Maanenberg 

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 yours Episodes from Project X that have not children issues.

issue not in parentsOfIssuesInQuery("") and Project = "X" AND type = Episode

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

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