How to display epic name with epic link OR parent

Question

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: <> <> > <> <> <> Issue 2 : Everything displays perfectly except <> and <> How do I display these 2 fields ?

Hannes Obweger - JXL for Jira · Answer

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

archana bhatt · Answer

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.

Thuan_ Do Dang · Answer

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!