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
I want help in writing a JQL query which will return all the tasks, subtask and risks related to epics and those epics have particular labels
Hi @Sayan Bera,
It might not be possible to create such JQL query.
But a possible solution to visualize the issues in such way is to use the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets plugin.
This gadget takes the issues from a specified filter and displays them in a tree structure, by their hierarchy, in form of Epics > Stories, Tasks > Sub-tasks, exactly as you want.
All you have to do it to have a filter that returns the issues to be grouped and to configure the gadget to use that filter.
In your case, you'll have to create and save a filter that returns only the epics with the specific labels and other non-epic issues to be listed by the gadget, by filtering them by project or more criteria. This is an example:
(issueType = Epic AND labels in (label1, label2)) OR (issueType != Epic AND project IN (project1, project2))
If you will configure the gadget to use this filter, it will display all the epics that you want to visualize with their child issues. It will also display some other issues under No epic category, but you can ignore that.
Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.
I hope this helps.