Issue Worksheet

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Elena Ovdienko

Saved on

compared with

New Version Current

changes.mady.by.user Elena Ovdienko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use JQL to customize Issue Spreadsheet

  1. Open Issue Spreadsheet.
  2. Click Switch to JQL.
  3. In the JQL query box, enter the JQL query using JQL. 
  4. Press Enter or click Search.

Select the columns for Issue Spreadsheet

  1. Open Issue Spreadsheet.
  2. Click Columns on the top right.
  3. Customize the order or delete the existing columns of Issue Spreadsheet on the Column order tab.
    Image Added
  4. Select the fields from Jira issues to be displayed in Issue Spreadsheet on the Fields tab.
    Image Added

The list of supported fields

Currently, you can select the fields below to show in Issue Spreadsheet. Contact us if you need more.

System fields

  • Assignee
  • Attachment
  • Comment
  • Created
  • Description
  • Due date
  • Environment
  • Issue Type
  • Key
  • Priority
  • Project
  • Reporter
  • Resolution
  • Status
  • Summary
  • Updated

Other fields

  • Date of First Response
  • Actual end
  • Actual start
  • Approvers
  • Change reason
  • Change risk
  • Change type
  • Components
  • Confidence
  • Creator
  • Ease
  • Epic Link
  • Epic Name
  • Epic Status
  • Fix versions
  • Flagged
  • Impact
  • Labels
  • Last Viewed
  • Linked Issues
  • Original estimate
  • Parent
  • Remaining Estimate
  • Request Type
  • Resolved
  • Sprint
  • Start date
  • Status Category Changed
  • Story point estimate
  • Story Points
  • Target end
  • Target start
  • Time Spent
  • Time tracking

Manage the Issue Spreadsheet view

...

  1. Open Issue Spreadsheet.
  2. Locate the View section.
  3. Select the required view.
  4. Make the changes you need in Issue Spreadsheet.
  5. The view is marked as Modified.
  6. Click the Update view button to save changes in the view settings.

Export Issue Spreadsheet

You can export the current page of  Issue Spreadsheet. Some of the fields can't be exported due to technical limitations. If you have any requests regarding this function, please, contact us. 

  1. Open Issue Spreadsheet.
  2. Locate the View section.
  3. Click theImage Added menu button.
  4. Choose the required option
    1. Export current page to CSV
    2. Export current page to JSON
  5. A file in the chosen format will be downloaded.

Image Added

Note that at the moment you can export only one current page of the spreadsheet at a time. If you need to export more than one page, you'll need to open the necessary page and download it manually.  Please, contact us, if you have any suggestions.

Known issues of the Issue Spreadsheet export

  1. Some fields are not exported due to technical limitations. At the moment, these fields can't be exported:
    1. Comment (html)
    2. Description (html)
    3. Environment (html)
    4. Approver groups
    5. Backout plan
    6. Implementation plan
    7. Major incident
    8. Responders
    9. Root cause (html)
    10. Severity
    11. Test plan
    12. Story Points
    13. Workaround (html)
  2. If you apply the Issue hierarchy function, only epics will be visible in the exported file.
  3. Jira fields without any values, like Unresolved or Unassigned, will be empty in an exported file.

Change the Jira issues from Issue Spreadsheet

You can edit multiple fields right from Issue Spreadsheet without switching to a Jira issue itself. Some of the fields can't be edited due to technical limitations. If you have any requests regarding this function, please, contact us.

Change task type

  1. On the list with Jira issues, locate the one which type you want to change.
  2. Hover over the task type icon and click it.
  3. Select the task type you want.

...