Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,551,973
Community Members
 
Community Events
184
Community Groups

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

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.

 

 

3 answers

0 votes
Rhys Diab _Agile Docs_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Sep 26, 2021

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.

agile-docs-v2-hero.png

 

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

0 votes
Rahul_RVS_Support
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Sep 08, 2021

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 statusesEpic Hierarchy.PNG

0 votes
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Sep 08, 2021

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. 

@Mikael Sandbergwe do have scriptrunner but still running into challenges.

Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Sep 09, 2021

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events