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

[Rosa Maria Figueras Ferrer]

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.

[Henri Seymour _Easy Agile_ · Accepted solution]

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]

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_]

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]

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_]

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

[Marc Rigby]

Hi Henri,

Any update on this feature?

Best,

Marc Rigby

[Henri Seymour _Easy Agile_]

Hi @Marc Rigby 

We don't have any updates on this feature, but we are currently exploring improvements to how incomplete actions are surfaced for teams. 

If you're an Easy Agile TeamRhythm user, we'd love your feedback in user interviews or prototype testing! Reach to us here to connect with our product research team. 

We don't have a timeline to share at this stage, but we'll update this thread when we have more information. 

Kind regards,
Henri, Support Engineer @ Easy Agile

[Luis Ortiz - Catapult Labs]

Hi, all!

I'm Luis, with Catapult Labs.

We've built the Agile Retrospectives for jira app and we do have a dashboard were you can filter all action items based on user, and wether or not it is marked as finished. A few more filters, and from open or finished retrospective sessions. 
We have a few other very helpful features like: a dashboard, session history, you can even export such history. Many great ways to improve follow-up, engagement and transparency for your retrospectives sessions. 
We've been working on the app for almost 7 years now (the first retros app in the atlassian marketplace, and the best-seller), and I can tell you it is great for teams of any size, and is built with distributed teams in mind. 
Check it out and give it a try, find out why teams of all sizes use our add-on. From small <10 member teams, to large enterprise customers of >30,000 users use our add-on to improve their session. 

Since you are member of the Atlassian community, I will be glad to provide you with an additional Discount code to make it a lot more affordable to your team. Reach out to me and I will be providing a discount, answer all of your questions, and we can schedule a demo if needed. 

luis.ortiz@catapultlabs.com

@Rosa Maria Figueras Ferrer 
@Oday Rafeh 
@Marc Rigby 

[Oday Rafeh]

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]

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

[Oday Rafeh]

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>"