The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
Any suggestions would be greatly appreciated.
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
Hi @FR Jira Dev
If you would be interested in an easy to use paid add-on to get this data, you can try out our plugin
Agile Tools : Epic Tree & Time in Status
The app provides the Epic Hierarchy based on multiple filters at Epic level including Epic statuses
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You cannot do nested JQLs like that without having an app. The issuesInEpics() function is provided by Scriptrunner, and there other apps in the Marketplace that also extends the standard JQL with additional functions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.