JQL query that return stories and linked open tasks in a given sprint.

[Reenu Sandhu]

I want help to construct a query that shows me all stories and their child tasks that are in certain status in a given sprint to track the sprint progress or reassignment.

[Daniel Turczanski - JQL Search Extensions]

Hi,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

sprint="My sprint" or issue in linkedIssuesOfQuery("Sprint='My Sprint'")

Check out the documentation to see more examples.

I hope this helps!
Daniel

[Alexander Bondarev]

Hi, @Daniel Turczanski - JQL Search Extensions !

Just want to say "thank you" for the app!

[Julia Shcherbyna _SaaSJet_]

Hi @Reenu Sandhu 

Welcome to the community!

As an alternative, try add-in Time in Status for Jira Cloud developed by my team.

Here you can get time data by Epics using the Pivot Table function. Here is a video tutorial that can help you.  And here is a detailed instruction on how to set it up.

In the report, you'll see time spend in each status by epics and tasks by the selected period.

If you have questions, be free to ask.

Regards

Julia

[RVS_Support]

Hi @Reenu Sandhu 

Welcome to the community !!

If you are using fixed versions and would be interested in a paid add-on, you can try out our plugin Agile Tools, to track progress of issues in your Links hierarchy and their status as well

Agile Tools - Epic Tree, Links Tree and Time in Status 

The add-on allows you to visualize your Links hierarchy with option to view all your custom fields on a single screen.

Key features of Links Hierarchy:

• Links Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

You get multiple other features as below in the same app

• More than 8 types of Time in Status Reports. Excel Export available for all status reports.
• Epic Hierarchy / Sum Up (Standard Jira Hierarchy Epic -> Story -> SubTask)
• Portfolio/Advanced roadmaps Hierarchy
• Worklogs Report
• Timesheet Entry screen
• Dashboard gadgets for all the reports