JQL Filter to display Epic and its child issues

[J Chan]

Hi, 

I am trying to create a filter to use for a timeline. The idea is to display specific epics and its child issues, the requester wants to only view or see their own epics 

[Trudy Claspill]

Hello @J Chan 

If you are using only native Jira functionality then you will have to create a filter like this with the explicit issue keys for the Epics you want to include:

issue in (<comma separated list of Epic issue keys) or

porfolioChildIssuesOf("<first Epic's issue key>") or 

porfolioChildIssuesOf("<second Epic's issue key>") or 

porfolioChildIssuesOf("<third Epic's issue key>") or ...

etc.

Another query that could work would be:

issue in (<comma separated list of Epic issue keys) or parent in (<comma separated list of Epic issue keys)

With some third party apps that extend the JQL capabilities it is possible to get the child issues of Epics based on a filter that gets the Epics. Do you have such an app or are you willing to purchase one?

[Trudy Claspill]

Hello @J Chan 

Did one of the responses provided help you solve your issue?

If so please consider clicking on the Accept Answer button above the answer that helped you solve your issue.

[Tori Hermione Baker]

Hi @Trudy Claspill 

I have also been looking at this trying to get a timeline view to work using External Share, and I cannot achieve a view of Epics with their grouped child Tasks, Stories.

It's driving me crazy, and I wonder if it is because this is a configured change for the Jira Timeline and isn't a query?! Very stuck

I haven't been able to achieve it, and I have spent a fair while researching and trying different queries/filters. 

And yet, no joy :(

[Trudy Claspill]

Hello @Tori Hermione Baker 

Please open a separate/new Question for your scenario, provide helpful information about your environment such as the hosting/deployment type (Cloud vs. Server/Data Center), you Plan subscription (if you are on Cloud - free, standard, premium, or enterprise), and the type of project(s) with which you are working.

If you post a link to your new question here, I may be able to take a look at it later.

[Hannes Obweger - JXL for Jira]

Hi @J Chan

I understand that you're looking to use the timeline view, but just to put it out there, in case it is useful: If you're open to solutions from the Atlassian Marketplace, the data that you're looking for would be trivial to retrieve in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like e.g. this in just a couple of clicks:

The "(Me)" filter that I'm using above always refers to the active user, meaning that you could easily prepare a fitting view for team.

Any questions just let me know,

Best,

Hannes

[Danut M _StonikByte_]

Hi @J Chan,

Try also: 

parentEpic IN (EPIC-1, EPIC-2, ...)

This filter would work better in combination with the Work Breakdown Structure gadget offered by our Great Gadgets app. This gadget displays the issues from a filter in a tree structure  in form of Epic > Stories, Tasks > Sub-tasks along with their status, thus giving you a quick overview about the overall project/epics status.

All you have to do is to configure it to use a filter or JQL:

parentEpic IN (EPIC-1, EPIC-2, ...)

Read more about this gadget and some others offered by the same app here: https://community.atlassian.com/t5/App-Central/8-gadgets-for-a-powerful-Scrum-dashboard-in-Jira/ba-p/1683063 

Hope this helps. 

Danut.