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
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
You can use the new JQL keywords together, for instance
"subTaskOfQuery = project = DEMO and issuetype = Bug
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:
This will allow using subTaskOfQuery = project = DEMO and issuetype = Bug together with all the new JQL keywords.
Hi Muhammad. I've read this document and am still not getting the query right. Here's what I have thus far:
I have a subquery I've aliased "MobileEpics" that is
issuetype = Epic AND (project = "Mobile: Android" OR project = "Mobile: iOS")
If I run
I get what I expect, a list of all the Epics in both projects. However, this query returns no results:
I expected to get a list of the Initiatives that are parents of the Epics?
I'm now attempting this with ScriptRunner instead. I'm using this:
issueFunction in parentsOf("(project = AN OR project = IOS) AND issuetype = Epic")
and it is returning no issues. I'm beginning to suspect that "parentOf" isn't set up properly for Initiatives with Epics as subtasks ?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events