How to display epic name with epic link OR parent

[archana bhatt]

This solution works for me partially.

My JQL looks like this:

project="XYZ" and "Epic link" in (e1,e2,e3)  or parent in (e1,e2,e3) 

Issue1: Status!=done doesn't work, it displays done items too.

I am trying to use this query in the "Filter results" gadget 

and adding the below fields:

<<Epic name>> <<Epic Status>> <Issue type>> <<Key>> <<Description>> <<status>>

Issue 2 : Everything displays perfectly except <<Epic name>> and <<Epic status>>

How do I display these 2 fields ?

[Thuan_ Do Dang]

Hi @archana bhatt ,

Issue 1: Remember to wrap 2 clauses of OR into (), your JQL will looks like: project="XYZ" and ("Epic link" in (e1,e2,e3)  or parent in (e1,e2,e3)) and status != Done

Issue 2: Epic name and Epic status have value if your issue is Epic only. You can use Epic link instead of them.

Hope this helps!

[archana bhatt]

Cool! That worked for the status and results. Thanks so much @Thuan_ Do Dang 

I see 2 more issues here:

1. I can only grab all the stories linked to these epics. Its not showing up any sub-tasks linked to it.

2. Instead of hand-picking epics (e1,e2...) is there a better way to reference all the epics by just querying labels?

This becomes tedious if we have more than 10 epics.

[Hannes Obweger - JXL for Jira]

Hi @archana bhatt, 

to both your points, this won't be possible using "native" JQL. You'll need an app from the Marketplace for that.

Two routes to go down:

First, there's a number of apps that provide extensions to native JQL; I haven't used them much myself, but e.g. JQL Search Extensions or Scriptrunner should provide useful capabilities.

Alternatively, there's a number of more hierarchy-focused apps in the Marketplace. These apps usually don't rely on "native" JQL to establish parent/child relationships, but have their own ways of doing so. I can only speak for the app that my team is working on - JXL for Jira - but in JXL, your use case would be easy to solve.

• Create a so-called sheet that includes any issues that could potentially be relevant to you. Don't worry about parent/child relationships; JXL will sort that out for you.
• Switch on the default hierarchy; that's a one-click operation.
• Configure filtering to apply only to top-level issues (i.e., your epics); again, a one-click operation.
• Now you use Excel-style column filtering and full-text search to navigate through your epics, always viewing their full hierarchy.

This is how it looks in action:

(Note that JXL can do much for than that: From quick inline editing (individually or in bulk), inline issue creation, to advanced features such as grouping, sum-ups, and conditional formatting.)

Hope this helps,

Best,

Hannes