I want to obtain a list of issues which are in the state "todo", but are in epics which have been closed as "done"
You need an app like Scriptrunner that adds a JQL function that allows you to use a sub-query in your JQL. Scriptrunner provides a function called "issuesInEpics" that does what you want.
Hi,
Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack if you are on Server / DataCenter, you can type the following:
1) Search for Open issues in closed epics
status = Open AND issue IN issuesInEpics(' status = Closed ')
Alternatively, using resolution field....
AND issue IN issuesInEpics(' resolution IS NOT EMPTY ')resolution = Unresolved
resolution 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:
References:
Nowhere near enough information in this answer, such as an example JQL that would illustrate how this function would be used to meet the OP.
Out-of-the-box JIRA does currently not support this.You need one of several possible extensions.We are using Scriptrunner. Which I believe solves this elegantly with its extended JQL functions. To solve the example above, I would write:
issueFunction in issuesInEpics("status = done") and status = todo
That should do it.
Breaking it down:To get access to any Scriptrunner function you start by writing. Syntax suggestions will appear after that
issueFunction in
In this case, use a specific Scriptrunner function "issuesInEpic" to return all issues under Epics matching the parameter in the function. The parameter can be any complexity of JQL.
issuesInEpics("status = done")
This result combined with normal JQL filtering to find only the ones in state "todo".
and status = Todo
I have written a full answer to this using Scriptrunner
It looks like you're new here. Sign in or register to get started.
![Photo of Jack Nolddor [Sweet Bananas]](https://us.v-cdn.net/6038660/uploads/avatars/b3/a6/nb3a6df9986a0e0eba72ad4e75c0a61f5.png)
