JQL Filter to display Epic and its child issues

J Chan March 27, 2024

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 

3 answers

2 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 27, 2024

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?

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 3, 2024

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:

my-epics-and-stories.gif

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

0 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2024

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.

image.png

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.

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events