I'd like to know how I can use a JQL query to collect Epics which do not yet have any issues linked to them.
It seems that I can find issues which have links out to an Epic, but not necessarily the other way round.
I'm looking for something like:
IssueType = Epic AND HasChildren = No
Hi @Jennifer McVicker
If you are on a Server JIRA you can use the add-on ScriptRunner for JIRA from Adaptavist, to easily create queries around Epics:
issueFunction in hasLinks("is Epic of") - to show all epics that has stories defined
issueFunction not in hasLinks("is Epic of") - well, to show all epics that has no stories defined
@Ste - did you use Script Runner for that query? We are currently not using any plugins or add ons like Script Runner but our members want to be able to see what Epics don't have children so they can work on getting them decomposed by the requester.
However, I cannot find a query via google or the JIRA Communities that would allow me to put together a query for that without using Script Runner or a tool like Script Runner.
Has anyone found that this (a query for Epics with no children) is possible without another tool , in JIRA?
Not that I know of - you need more powerful queries to allow you to do this.
Without any app, you'd have to take more manual steps - such as:
^ This seems like a lot of manual steps though - is there a reason you wouldn't want to get ScriptRunner or another JQL enhancer (there are many!)?
I'm looking for the answer to this too...or rather, the reverse. I have created a board that pulls stories and epics from multiple projects, and I want to ONLY pull in epics that contain one or more stories that display on my board. For instance, an epic may have three stories but those three stories are filtered out by my board filter, so the epic shows up on the backlog screen, but contains no stories on my board.
Oddly, there was an answer using JQL Search Extensions above that didn't work for me. Instead, I had to use this JQL for my search. Adding this here in case it helps some other folks...took me a while to get this working.
issue not in epicOf("'Epic Link' is not empty")) ORDER BY rank
I use Structure as well; in my one filter, I wanted to show all the other issues as well, so I had JQL something similar to the following:
issuetype not in (sub-task,test, epic) or
(issuetype = Epic and issue not in epicOf("'Epic Link' is not empty"))
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