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

[Samantha Du]

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 

[mauricio.groth]

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

[Jack Brickey]

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

[Jack Brickey]

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