Questions about JQL

[Jason Liu]

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.

[Hannes Obweger - JXL for Jira]

Hi @Jason Liu

welcome to the community!

Unfortunately, "plain" Jira isn't too great with searching across issue hierarchies, so to the best of my knowledge, you'll need extra tooling to solve your use case. A few directions forward:

• This should be possible in Advanced Roadmaps, since it has great support for issue hierarchies. If you create a plan that contains all the relevant stories, plus any potential sub-tasks, AR should show the sub-tasks under their stories, and all other sub-tasks in a special "other issues" "basket" that you can ignore.
• There's different apps from the Atlassian Marketplace that can help with that. On the one hand, there's a number of apps that extend JQL by additional functions, including hierarchy-related functions. I've used JQL Search Extensions a few times and it works great. The disadvantage is that you'll always only see your issues as a flat list, rather than in their hierarchy.
• Alternatively, you could try one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways to define and navigate through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve; I'll provide more details below.

Hope this helps,

Best,

Hannes

Edit: I see that you've tagged for question for Jira Server. You may have heard that Server apps are no longer available via the Atlassian Marketplace. Are you planning to move to Data Center or Cloud in the foreseeable future? I'd strongly recommend that. If not, you may be able to arrange something with the respective app vendor.

[Jason Liu]

Thank you so much, Hannes. We are planning to move to Data Center but I think it will take a while. New plug-in is not considered.

[Hannes Obweger - JXL for Jira]

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

[Mohamed Benziane]

Hi,

this is not possible out of the box, may be a plugin like scriptrunner can achieve this.

[Jason Liu]

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

[Rahul_RVS]

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