Overview

If you need to export your Jira issues to an external file like CSV and include the Component Versions from Octo in one of the columns, Jira’s native export functionality can help. However, it has a significant limitation: it only allows exporting a maximum of 1,000 issues at a time.

The Google Sheets add-on for Jira can be a game-changer for exports involving more than 1,000 issues. This guide explains how to configure the export correctly, as the default settings will result in a [no field found] error for the Component Versions column.

Step-by-step guide

Step 1: Create a JQL Query in Jira

First, define the issues you want to export by creating a JQL query. For example:

This query will filter for issues in project ABC where the Component Versions field is populated.

Step 2: Link Jira to Google Sheets

If you haven’t already connected Jira to Google Sheets, follow these steps:

1. In Jira, go to Apps > Open in Google Sheets.

2. Follow the on-screen instructions to establish the connection.

Step 3: Addressing the '[no field found]' Error

When you open the generated sheet after using the ‘Open in Google Sheets’ export, you might notice the Component Versions column shows a '[no field found]' error instead of actual data. This is expected due to Jira Cloud for Sheets cannot parse Jira columns of type list by default.

You can close this spreadsheet, as it won’t be useful for our purpose.

Step 4: Create a New Spreadsheet with the Correct Configuration

1. Open a new Google Sheet.

2. Go to Extensions > Jira Cloud for Sheets > Open.

3. Click Get issues from Jira.

4. Change the Import Type to =Jira() and enable the Jira function.

Step 5: Use the =Jira() Function

To fetch your issues with the correct fields, follow these steps:

1. In cell A1 of the new spreadsheet, enter the following formula:

   =Jira("<your JQL>", "<fields you want to include>", <range of issues>)

   Example:

   =Jira("project = lotsofissues", "key, summary, Component Versions.value", 0, 20000)

2. Adjust the parameters as follows:

   • Replace <your JQL> with your Jira query.

   • Replace <fields you want to include> with the columns you need, ensuring you use Component Versions.value (more details below).

   • Specify the range of issues to retrieve (e.g., 0, 20000).