Query for Tasks and Subtasks of Unresolved Epics in a given project

Question

We have tried a few jql and script runner advanced queries to show all open and resolved tasks and subtasks in a given project that are linked to epics that are open.  The query should exclude any issues that are tied to a resolved epic.

Suggested scripts like issueFunction in issuesInEpics ("project=JRA and status = 'to do, in progress, approved'") do not return issues and provide an error

Function 'issuesInEpics ' does not exist

Any suggestions would be greatly appreciated.

Eduardo Godinez · Answer

I use this query to list any subtasks that are unresolved within an Epic:

parent in (JIRA-1234) AND resolution = unresolved

Just replace JIRA-1234 with the epic key and you'll see everything that's pending for the epic.

^^ This will only show subtasks ^^

Use this query to list any tasks that are unresolved:

"Parent Link" = JIRA-1234 AND issuetype = Task AND resolution = unresolved

Rhys Diab _Rogue Wombat Software_ · Answer

Hi @FR Jira Dev

We created a plugin called Agile Docs which can help you show those issues.

You can create a filter for all unresolved Epics in your project and bring it up in Agile Docs. Agile Docs will show you all issues in that Epic and the children of those issues.

If you have the Epic keys, you can use the "All Parent Issues" field which is maintained by Agile Docs to write a JQL query which brings up those issues directly. It will bring up all the children and children of children of any issue.

So your query to bring up all tasks and sub-tasks might look:

"All Parent Issues" in (epickey-1, epickey-2, epickey-3)

Best Regards,

Rhys

Mikael Sandberg · Answer

Okay, I think I have seen this in the past, but it was on Server and happened when Scriptrunner either failed an update or didn't load correctly. I will move this into the Adaptavist section, and they should be able to help you get the JQL working.