How to find Issues related to an Epic Query

[Management Team]

I need help to filter in a way that returns Issues under a list of Epics (I've already defined the list of Epics using a Filter).

So, the structure of my project is as follows:

• Epic 1
  • Issue 1
  • Issue 2
  • Issue 3
• Epic 2
  • Issue 4
  • Issue 5
• Epic 3
  • Issue 6
• Epic 4
  • Issue 7

Each Epic has two custom fields - Theme (Checkbox) and Business Line (Dropdown). They're assigned as below:

• Epic 1 - BL1 AND Theme 1
• Epic 2 - BL1 AND Theme 1, Theme 2
• Epic 3 - BL1 AND Theme 1, Theme 3
• Epic 4 - BL2 AND Theme 2

I can filter for BL1, which returns Epic 1, Epic 2, and Epic 3. Similarly, I can filter for Theme 2, which returns Epic 2 and Epic 4. What I'm struggling with is finding a way of returning corresponding Issues. I want to filter so that for BL1, I can show Issues 1-6, and for Theme 2, I want to show Issues 4, 5, and 7. Is there a way of doing this?

I have already considered using ParentEpic, which didn't work (it's a team-managed rather than admin-managed project). Any thoughts?

ps: please ignore my name - this is a company account, and not affiliated with the Jira mgt team in any way, shape or form!

[RVS_Support]

Hi @Management Team 

Welcome to the community !!

As an alternative, you can try out our app:

Issue Hierarchy Reports 

The app is very flexible and you can use custom JQL for top level issues and a different JQL for child issues. I believe this will help meet your use case. 

The app is free upto 10 users. Do try it out.

Disclaimer : I am part of the team which developed this app

[Bill Sheboy]

Hi @Management Team -- Welcome to the Atlassian Community!

You cannot perform a query like that with out-of-the-box JQL.  (It is not a SQL, and does not have such features.)

Do you have any marketplace addons/apps which extend the features of JQL?  If so, one of them may help.

If not, and you do not need a query like this often, you have a couple of options:

• export the issues to a spreadsheet and perform the join there
• 2 queries
  • first query to find the epics
  • use the results to create a comma-separated values (CSV) list of the epic keys, like this (Epic-1, Epic-2, Epic-3)
  • now create a second query to find all issues, like this:
    • key IN (Epic-1, Epic-2, Epic-3) OR parent IN (Epic-1, Epic-2, Epic-3)

Kind regards,
Bill

[Management Team]

Thanks Bill... yeah, from browsing the other, similar comments, I thought it would be a tricky ask. 

Browsed the marketplace apps, but nothing seemed like it would do the trick in the way I'm looking at.

The idea was to have it more dynamic - so task boards and backlogs can shift depending on which business line etc. we're talking to. Extracting and statically pulling the Epics doesn't solve our challenge... it looks like it'll have to remain unsolved and we'll work around for the time being.

Cheers for the help - appreciate it!