You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hello, I'm using Jira within my project (RNA).
I am looking for a JQL Query that I can use to return all descendant issues of an epic.
In this project, we only have 1 issue type other than Epic, called "Task".
We also use Sub-Tasks within Tasks.
Sub-Task = RNA-850
Solutions I've tried that do not work for me include:
The solution I know will work, but is not dynamic and requires constant updating:
Unfortunately, this solution requires me to update my query and add the additional "Tasks" or parents to my query each time I add a new task.
Could you please help me find a more dynamic way to query these issues?
I think you can achieve that with a 2-part JQL.
Unfortunately, you will need to specify your epic twice:
issueFunction in issuesInEpics('key=RNA-1') or issueFunction in subtasksOf("issueFunction in issuesInEpics('key=RNA-1')")
The first part will get you the list of tasks. The second part will get you the SubTasks for all the issues in the first part.
Or you can try
issueFunction in linkedIssuesOfAllRecursive('key=RNA-1')
But that will also include the EPIC in the result and any other linked issues
please have a good read-through of Atlassian Community online guidelines for Marketplace vendors and Solution Partners as they provide guidance on how to act around the community as a marketplace vendor. This includes the various way of identifying yourself as a partner (e.g., putting the vendor name in the user name) and clearly stating your affiliation with the company providing those products or services. Please play fair here as other app vendors are judged by the same standard and always keep in mind that your primary goal should be to help the user and not solely promote your application as a solution. Thank you very much! 👍🏻
Hi @Prasad Andrews ,
Take a look at Power Utilities for Jira app. It has JQL functions that should work for you:
issuesParents(JQLquery) - returns a list of issues that are parents of all issues inside the specified JQL query (e.x. issue in issuesParents("Project = PRDT"))
issuesSubtasks(JQLquery) - returns a list of issues that are subtasks of all issues in the specified JQL query (e.x. issue in issuesSubtasks("Project = PRDT"))