I want search all the issues, which has no child ticket, how to write JQL?

Samantha Du December 16, 2021

I have a lot of issue tickets,

1 some of them, I created the link with another one by "child of"

2 some of them, I did not create any link

and I want to search part 2 by JQL 

3 answers

0 votes
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 27, 2022

Hi @Samantha Du ,

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.


With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

If you want to search for all the Epics that don’t have children, you can use this query:


issue in epicsOfChildrenInQuery ("project = ’TestProject’")


TestProject is the name of your project that contains the issues.

After this, you save it, in “save the query as a filter”

Then, you access the “Advanced issue search”, in Jira and use this query:


filter != “FilternName” and type = epic


FilterName is the name of your saved filter.

Could you please confirm if this is what you are looking for?

If not, could you give me more information to help you?

Check out the documentation for more examples.
I hope this helps!
Maurício

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 16, 2021

You can’t do that OOTB. you might consider Scriptrunner 

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 16, 2021

You can’t do that OOTB. With Scriptrunner you could use type in standardissuetypes()

Suggest an answer

Log in or Sign up to answer