Query to find all initiatives with child issues in a set of projects?

Janene Pappas

I'm attempting to craft a query to get a list of all Initiatives that contain Epics in 2 specific projects. 

I've installed the trial version of JQL Search Extensions am experimenting with subqueries but I'm not quite there yet. 

If I have a subquery, call it MyEpics: 

issuetype = Epic AND (project = "A" OR project = "B")

how do I then use that to get something on the order of

issuetype = Initiative AND subtasks in MyEpics

 

Muhammad Ramzan_Atlassian Certified Master_

If i correctly understand you are using JQL Search Extensions for Jira & reports plugin 

 

you can try following example and it will work in your scenario. In your case you need to replace issuetype from bug to Epic

 

Nested queries 

You can use the new JQL keywords together, for instance 

Example

"subTaskOfQuery = project = DEMO and issuetype = BuglinkedByQuery=<span>&nbsp;</span>

The query above finds all issues which are linked by the subtasks of the bugs in the project demo. In order for this functionality to work, please first:

1. Define a subquery: project = DEMO and issuetype = Bug
2. Define another subquery that uses the first subquery: subTaskOfQuery = project = DEMO and issuetype = Bug

This will allow using subTaskOfQuery = project = DEMO and issuetype = Bug together with all the new JQL keywords. 

 

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/173211649/Subqueries+-+Jira+Cloud#Subqueries-JiraCloud-issuesFromEpicsInQuery