How can I get the list of action items from all Jira agile retrospectives of a project?

Rosa Maria Figueras Ferrer April 2, 2024

We began to use the board Retrospective in our retro scrum event of each sprint. We populate the columns (using a template) and we also populate the column Action with Action Items. Some Action Items are directly converted into issues into our project backlog but some other Action Items will remain, checked (when the action item is finished) or unchecked (otherwise).
We would like to get a list of all action items together with the state of the check button.
Is there any function or any way to get the list of all action items we wrote in our retrospective events and the link to the sprint where it has been created?
Now we have to do a manual task outside Jira to gather all this information.
We would be very grateful to get this information directly in Jira.

2 answers

1 accepted

0 votes
Answer accepted
Henri Seymour _Easy Agile_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 2, 2024

Hi @Rosa Maria Figueras Ferrer 

This will depend on what tool you use to run your retrospective sessions! Jira doesn't have an inbuilt Retrospective tool. 

  • @Oday Rafeh's suggestion will work if you use a custom issue type named "Retrospective" to create your retrospectives. 
  • Some teams use the Retrospective Template in Confluence. 
  • There are a range of apps on the Atlassian Marketplace for adding a Retrospective tool to Jira. For help with those, I recommend reaching out directly to the company behind the app. 

 

I work for Easy Agile, the team behind the Easy Agile TeamRhythm app.

If you're using the Retrospective page in Easy Agile TeamRhythm, it unfortunately isn't yet possible to produce a report of all the action items from retrospectives. In-app-only action items (which have a checkbox) won't appear in Jira, and can't be located with a JQL search.

On Jira Data Center, they will be stored in additional tables in the Jira database. Accessing this typically requires Jira Administrator permission and a database query language (like SQL). 

Kind regards, 
Henri, Support Engineer @ Easy Agile 

Rosa Maria Figueras Ferrer April 3, 2024

Thanks,

we used Miro first and Mural then in our Scrum Events, but we decided to move to Atlassian Jira retrospective because it is embedded in Jira and it offers all we need, as for example, 4L's Style template. The user experience is better because Dev Team prefers to write directly in the columns than move postits.

Best
Rosa M. Figueras Ferrer

Henri Seymour _Easy Agile_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 3, 2024

Hi Rosa, 

To the best of my knowledge, Atlassian Jira doesn't have a retrospective tool. Apps like Easy Agile TeamRhythm can embed a Retrospective page for this. 

So we can understand what tool you're using, could you share with us a screenshot of the page you're using, or the URL format? 

  • eg. .../secure/RapidBoard.jspa?rapidView=123&projectKey=ABC&view=planning&issueLimit=100# is the URL format for the Backlog page of a Scrum board. 

Kind regards, 
Henri, Support Engineer @ Easy Agile 

Rosa Maria Figueras Ferrer April 8, 2024

Hi Henri,

we use the Easy Agile TeamRhythm app. 

Unfortunately, I am not an administrator of JIRA and as you told there is not any way to get all Action Items from all retrospectives.

I suggest you to add some aproppiate funcionality that could cover the need I asked for because not all Action Items are going to be converted in Jira Issues. If you have to go back to any retro and search for an item not checked it will be a tedious work,

I am very grateful for your response.

 

Henri Seymour _Easy Agile_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 9, 2024

Hi @Rosa Maria Figueras Ferrer 

Thanks for confirming this request is for Easy Agile TeamRhythm. 

I've passed your feedback on to our product team, with a vote on your behalf for this functionality. While we don't currently have a timeline for this, we'll let you know if we have any updates on the topic! 

Kind regards,
Henri, Support Engineer @ Easy Agile

0 votes
Oday Rafeh
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.
April 2, 2024

Hi @Rosa Maria Figueras Ferrer and Welcome Here :) 

Unfortunately, there's no built-in way to do this directly in Jira.

you can use Search with JQL 

Go to “Search” in your Jira project.

Type a JQL query like the one ima providing (replace <your_project_key> with your actual project code):

project = <your_project_key> AND issuetype = “Retrospective”


This search will show all your past retrospectives.

The catch: You'll need to manually scan each retrospective's description (where you might write action items) to find them.

 Or you can check some Apps in the Atlassian Marketplace. 

Hope this help you 

Regards 

Oday

Rosa Maria Figueras Ferrer April 3, 2024

Thanks a lot,

I used the Search with JQL you proposed but I got the following error:

The value '“Retrospective”' does not exist for the field 'issuetype'.

I got all the types from REST Api meta

<our local environment>/rest/api/2/issue/createmeta/<project>/issuetypes 

but I did not get any issue type referred to "Retrospective" or similar to "Action Item".

 

Best,

Rosa M. Figueras Ferrer

Like Oday Rafeh likes this
Oday Rafeh
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.
April 3, 2024

Hi @Rosa Maria Figueras Ferrer , 


Using the REST API as you did to confirm the actual issue type used for your retrospectives (e.g., “Scrum Retrospective” or a custom type).

project = <your_project_key> AND issuetype = "<actual_retrospective_type>"

 

Suggest an answer

Log in or Sign up to answer