JQL to list up all new features without a child-issue

Question

Hi,

So we have several issues of the type "New Feature". Most are linked to other issues of type "Epic". Some not.

We want a JQL that shows us the "New Features" that doesn't contain any Child issue with subqueries.

I already have these queries that works:

project = YYYYYY and issue in childIssuesOf("YYYYYY-1799") --> This gives no results and is correct because there are 
project = YYYYYY and issue in childIssuesOf("YYYYYY-1777") --> Gives us a list back of child issues

We have this query that gives us a list of all "New Features":
project = YYYYYY AND type = "New Feature" AND status not in (Done, Closed)

How can we add this query into the first one? So that we don't have to add manually each feature and then check and just get a list of Features that doesn't contain Child issues

Thanks ina dvance.

sven.cipido.external · Answer

Hi,

Not subtasks, but the the childs of "New Feature". So All "New Features" who doesn't have a child issue.

For the moment we don't have scriptrunner and it will not be there the couple next months.

So hopefully it is possible without scriptrunner.

Hazwan Ariffin · Answer

So you'd want to list all features that has no sub task, is that right. JIRA Cloud doesn't have such JQL query natively, but with the help of Scriptrunner you'll be to find all Feature with no sub task by running this JQL:

issueFunction not in hasSubtasks() and project = YYYYYY AND type = "New Feature" AND status not in (Done, Closed)

For more information see https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html