Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

JQL to Return Epics and Stories with link type mitigated by, and also children of an epic

(project = "IS") OR (project In ("AO","CE","DET","EEBT","KNIGHTS") AND (issueLinkType IN ("mitigates ","Is mitigated by") OR [child of epic that has a link type of mitigates] ))

Here is my query.  Works great except for the plain english part I am asking about here.  

I need it to return Issues (Epics and Stories) that have a link type of mitigates, but I also want it to return the children of the epic with the link type mitigates.  

Using the exception JXL:
Hierarchy is

  •  IS Issue Type
    • Epics or Stories with link type Mitigated by
      • Stories that are children of Epics with the link type of Mitigated by

2 answers

1 vote
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.
May 04, 2023 • edited

Hi @Jim Byers

do I understand correctly that you want to see this hierarchy in JXL?

If this is the case, you shouldn't really have to worry too much about the JQL statement, but let JXL do its magic through a custom issue structure. Here's how I would go with this:

1.) Create a new sheet with a sheet scope (i.e., JQL statement) that includes any issues that could be potentially relevant for your hierarchy. Looking at your current query, this could be

(project = "IS") OR (project In ("AO","CE","DET","EEBT","KNIGHTS") AND (issueLinkType IN ("mitigates ","Is mitigated by") OR issuetype = "Story"))

... but depending on the amount of issues we're dealing with, this could potentially also be much broader, like

project In ("IS", "AO"," CE", "DET", "EEBT", "KNIGHTS")

The important thing is that you don't really have to worry about the epic/story relationship - JXL will sort this out for you!

2.) In your sheet, configure a structure that looks similar to this:


3.) You should now see your issue hierarchy! Depending on your exact JQL statement, there will likely be some issues in there that are "outside" of your hierarchy and you don't really care about. You can simply hide these via the level visibility settings, like so:


... and this should be it!

Please let me know if this works. If there's any further questions, it may be easier to reach out to us directly - we're here to help!


Hannes from the JXL team

0 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.
May 04, 2023

Hello @Jim Byers 

Welcome to the Atlassian community.

Natively Jira does not have a JQL feature to enable you to retrieve children of multiple Epics unless you want to explicitly list the Epic issue keys.

There are third party apps that provide additional JQL functionality that would enable you do retrieve children of Epics where you provide a JQL for the Epics themselves. Adaptavist ScriptRunner is one such app. It provides an issuesInEpics() function that takes a JQL statement as its parameter.

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events