JQL for Epics, Featues and Stories

[Bradley]

Ok this is complicated so let me try.  So we have Product Epics, Features and Stories. The problem is Product Epics are on Jira Project A, All features on are on Jira Project B, and stories are on Project C.  I am wanting to pull a JQL that essentially shows me all Epics on Project A, Relates to all Features on B, and then all Stories from C onto a Dashboard. 

Can this be done and does anyone know how to write it? 

[Mirek]

Hi @Bradley 

Are there any links / relations between those tickets? Do you have any plugins or extensions like Script Runner that might give us more JQL options. Looking at the labels you use Jira Core not Software, correct? 

[Bradley]

What about using ScriptRunner? 

[Bradley]

We are using "Feature Link" and Parent Child. The "Feature link" is from Story to Feature, and then Parent Child is from Feature to Epic

[Mikael Sandberg]

You would need an app in order to do it since default JQL cannot do nested queries in order to get the result you are looking for. I have used JQL Tricks and Scriptrunner on Server in the past to do similar searches, but there are other apps in the Marketplace that enhances JQL.

[Bradley]

We do have scriptrunner

[Danut M _StonikByte_]

Hi @Bradley,

Try the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets app. 

This gadget displays the issues from a regular Jira filter in a hierarchical order, in form of Epics > Stories, Tasks >  SubTasks along with their status. 

All you have to do is to create a Jira filter that includes all the issues to be grouped, and then  to configure the gadget to use that filter.

Please note that this app offers many other gadgets that you will find useful. See the articles from our blog, to make an idea.

I hope this helps. If you need any help with the configuration, please don't hesitate to contact us at support@stonikbyte.com. 

Danut.