Require a JQL Query that will pull all initiatives within a project that DO NOT have any child issue

[Krista Guzewicz]

In an attempt to facilitate data clean up we require a list of initiatives that do not have any child issues (EPICS) so that we can provide the list to users and ask them to make the appropriate updates.  

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Krista,

Sadly, you cannot achieve the desired search using standard features on Jira. For this requirement you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Search 'Initiatives' not having child Epics

type = Initiative AND issue NOT IN portfolioParentOf(' type = Epic AND "Parent Link" IS NOT EMPTY ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Hope this helps you to create awesome queries <3

[Jack Nolddor _Sweet Bananas_]

Are you currently using Portforlio for Jira? If not, please telll us if your Initiatives are linked to using the standar issue linking feature.

Regards

[Krista Guzewicz]

We currently are using Portfolio Server 3.18 and the initiatives have parent workstreams