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!


Filter query that orders Stories with their Subtasks


I´m searching for a filter query, that shows Stories together with their Subtasks and orders them together.

It should be ordered like that:

Subtask (Child of Story#1)
Subtask (Child of Story#1)
Subtask (Child of Story#1)

Subtask (Child of Story#2)
Subtask (Child of Story#2)

Subtask (Child of Story#3)
Subtask (Child of Story#3)


Thanks for your help in advance.

3 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.
Oct 05, 2023

Hi @Tobias Rettensteiner

this is indeed not possible as a filter or JQL search. There are, however, a number of views in Jira that provide a hierarchical view:

  • If you have Jira Software Premium, this is available in Advanced Roadmaps.
  • If you have Jira Work Management, the list view should also do that. Disadvantage is that it only works for (and within) JWM projects.

As an alternative, there's a number of hierarchy-focused apps available in the Marketplace. E.g., my team and I work on an app that I think you might like, JXL for Jira. This is how it looks in action:


For context, 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.

Any questions just let me know,



0 votes
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.
Oct 05, 2023

Hi @Tobias Rettensteiner 

You will need Advanced Roadmaps to get this view. This can be also be achieved using a JWM project. 

Another option could be to use a mktplace app. If you are open for the same, you can try out an add-on we have built for the same use case.

Issue Hierarchy Reports 

You can view your issue hierarchies in a tree structure and track the progress at each parent level with sum ups of time estimates or story points. Also the app is very flexible and you can use custom JQL for top level issues and a different JQL for child issues. 

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

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

Epic Hierarchy - Gadget.PNG

0 votes
Craig Nodwell
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 04, 2023

Hi @Tobias Rettensteiner jira doesn't work that way.  At least not that I am aware of.

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events