How can I retrieve all my previous Sprint goals?

Question

I want to build up my teams dashboard. One of the returning questions is, how I can retrieve the Sprint goals in a specific year or period of time?

I have created those kind of queries in the past, but am afraind I might be confused as well with extended experience with Azure DevOps.

Can you help to with this question on JIRA queries and customized reporting (visibility).
Thanks

Fabio Racobaldo _Catworkx_ · Accepted Answer

Hi @Alwin Brands and welcome,

you can use the following jql to retrive specific sprint goal :

project = "YOUR_PROJECT_HERE" and sprint = "YOUR_SPRINT_NAME_HERE"

"Sprint goals in a specific year or period of time" is incorrect. Sprint is something that has internally a start date and end date so you should be able to search issues in a sprint without considering a period of time.

Hope this helps,

Fabio

Hannes Obweger - JXL for Jira · Accepted Answer

Hi @Alwin Brands

that's an interest one. My first reaction was to not approach it via issues, but maybe via Jira's sprint report(s), but I can't actually find a good way to view this there either.

As an alternative, and following an issue-based approach, you should be able to solve your use case in the app that my team and I are working on: JXL for Jira.

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 range of advanced features, including support for issue grouping by any issue field(s), and
* a long list of so-called smart columns that aren’t natively available, including the issue's sprint goal (i.e., the sprint goal of the issue's latest sprint).

With these, you can build a view like e.g. this in just a few clicks:

As every JXL sheet is powered by a JQL statement or saved filter, you have full control over which issues you want to include. I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to sum-ups or conditional formatting.

Any questions just let me know,

Best,

Hannes

Bill Sheboy · Accepted Answer

Hi @Alwin Brands -- Welcome to the Atlassian Community!

Do you mean the Sprint Goal entered for a Sprint from the Jira backlog?

If so, that information is only visible from the built-in reports, such as the Sprint Report, or on the board during the active Sprint.  To access the information for other purposes, one could use the REST API endpoint to get the Sprint data.

Kind regards,
Bill

Alexey Pavlenko _App Developer_ · Accepted Answer

Hi @Alwin Brands ,

As far as I know, JIRA doesn't natively allow users to see sprint goals for all sprints throughout a year, but I know for sure that you can easily retrieve it with the app I developed - Multi-team Scrum Metrics & Retrospective.

You can choose Period (X-Axis) = Sprints and select the number of sprints you have in a year. In this case you will get this view:

or you can select Period (X-Axis) = Year and after that use the drill-down feature to open sprints one by one within a certain month.

Note that you can see several boards/teams at once in a single view.

Best regards,
Alexey

Alwin Brands_ox0aeg · Accepted Answer

Thanks everyone for your answers. Multiple answers makes sense, I think ;-) I will investigate and experiment the suggestions.