Questions about JQL

Question

Does anyone know how to use JQL to search multiple stories and their sub-tasks. I want to have story 1 follow its sub-tasks and then story 2 and sub-tasks, this kind of sort.

Story 1

Sub-task 1 of Story 1

Sub-task 2 of Story 1

Story 2

Sub-task 3 of Story 2

Sub-task 4 of Story 2

Another question, I want to search stories and their sub-tasks of Epic link = Epic-1. But sub-task cannot have epic link. So how can I gather all the stories and their sub-tasks?

Thank you.

Rahul_RVS · Answer

Hi @Jason Liu

As mentioned by other community members, an app will help get this hierarchy.

If you are fine with it, you can try out our add-on.

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

Disclaimer : I work for the vendor who built this app

Hannes Obweger - JXL for Jira · Answer

Just to expand on the last point, this is how this would look in the app that my team is working on, JXL for Jira; TLDR: You can simply load your relevant issues into a sheet, enable the default issue hierarchy (that's just one click), and then filter down to the stories or epics that you care about.

Once you've narrowed down your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

In case you plan to stay on Jira Server: JXL is perfectly compatible; it's just that we need to generate a license for you. If the above looks interesting, just let me know and I'll happily start a free trial for you.

Any questions just let me know,

Best,

Hannes

Jason Liu_7ceche · Answer

Hi Mohamed, we have scriptrunner in our system. Do you know which function can achieve this?