JQL to NOT show Child Task

[Áine Flynn]

I am trying to return a search of tickets that does NOT show child tasks

[Nic Brough -Adaptavist-]

Try adding

and issuetype not in subtasktypes()

or

and issuetype in standardissuetypes()

[mauricio.groth]

Hi @Áine Flynn

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 than that, 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

For example, you can use this query to find all your issues that aren’t children’s tasks.

issue not in childrenOfIssuesInQuery("") and type = Task

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício