Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-159

Google Sheet Add-on for Jira Cloud can't export Comment Field

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Description

      Being able to use the Jira Cloud Add-on for Google sheet is a helpful way to be able to export thousands of issues at the same time rather than going through the 1K limit on Jira. However there are certain fields that can't get exported such as comment field. Basically this feature doesn't seem to exist yet for the Add-on.

      Steps to Reproduce

      1. Use the guide here https://community.atlassian.com/t5/Jira-articles/Try-the-new-Jira-Cloud-add-on-for-Google-Sheets/ba-p/1016436 to export your Jira Issues
      2. Use a Sample Jira function on Google Sheet as below 
        =JIRA("project = AT2 order by created desc", "issuekey, summary, status, assignee, created, comment, priority, labels", 0, 1000)
      3. Notice the error [can't parse subfield]

      Expected

      The comments should be exported separated by a comma, or each comment should have it's own column

      Actual

      The comment column has this error [can't parse subfield]

      Workaround

      There is currently no workaround available

            [API-159] Google Sheet Add-on for Jira Cloud can't export Comment Field

            Rahul Patil (Inactive) added a comment -

            ddbf258b40a2 yes, you should be able to import comments and some of the subfields within it, please use the side panel and from the field selection tab select comment and/or subfields within it.

            Kindly note that selecting subfields under comment will enable row expansion, what that essentially means is for a single issue you might get multiple rows returned based on the # of comments you have for the said issue.

            Rahul Patil (Inactive) added a comment - ddbf258b40a2  yes, you should be able to import comments and some of the subfields within it, please use the side panel and from the field selection tab select comment and/or subfields within it. Kindly note that selecting subfields under comment will enable row expansion, what that essentially means is for a single issue you might get multiple rows returned based on the # of comments you have for the said issue.

            grant.mckechnie added a comment -

            Is there any update on this @Rahul ? 

             

             

            grant.mckechnie added a comment - Is there any update on this @Rahul ?     

            Rahul Patil (Inactive) added a comment -

            Support for comment is enabled as part of the row expansion release which is gated currently.

            Rahul Patil (Inactive) added a comment - Support for comment is enabled as part of the row expansion release which is gated currently.

              rpatil@atlassian.com Rahul Patil (Inactive)
              hnyeche Prince N
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: