how to find the parent issues which dont have child issues?

Question

i want  the parent issues which dont have child issues in jira by using JQL Query

Vikrant Yadav · Answer

Hi @shashi budidha  If you have Scriptrunner plugin , you can search those parent issues using following JQL :-

issueFunction not in parentsOf("issuetype = Sub-task")

Thanks

V.Y

Fabio Racobaldo _Catworkx_ · Answer

Hi @shashi budidha ,

you can try using https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-reports?hosting=server&tab=overview&utm_source=atlassiancommunity&utm_medium=listinglink&utm_campaign=muhammad&_ga=2.61020780.1737260075.1578818764-294600771.1565082059 app.

In particular, there is the following https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3195142182/Subtasks+JQL+functions#SubtasksCount that could help you.

Hope this helps,

Fabio