Help for query to return all tasks related to a particular epic and particular epic label combined

[Sayan Bera]

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

[Danut M _StonikByte_]

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. 

Thank you,

Danut