I can create a spreadsheet report of tickets that shows the priority icon, but I need to display the name (or convert that to another value).
Hello Milo,
Thank you for reaching out.
Indeed, most of Jira reports use the priority icon instead of the priority name of the issues, however, if you only need a spreadsheet report containing some specific issue fields and the name of the respective Priorities, you can simply export your issues in a CSV spreadsheet and use any external software (Like google sheets) to display it. These would be the steps:
- Navigate to your issue navigator > Create a filter to return all the issues you want
- Selecting the List View, add all the columns (fields) you want your report to display:
- Select to export > Export Excel (Current Fields)
Let us know if this information helps.
Actually that is the whole reason for wanting priority words. The user making the request needs to extract data and was hoping to minimize the manual labor of filling in / changing data.
Thank you for your answer.
Sorry, but I think I did not manage to fully understand your request. Please, allow me to ask you some questions so we can better know we're on the same page:
As mentioned above, the export to CSV contains the priority words, Not the Icon field. For the CSV view, the issue will display the Icon of the priority itself, but once the data is extracted the priority name will appear in the respective CSV Column/field. That being said:
- Can you please give us more details on how they want to minimize the manual labor of filling in / changing data?
- Why they would need to have the priority field name before exporting the Issues since it can be defined in the JQL itself?
OK, thank you for following up! I got your first response to work, and while there are still a few steps, it's probably good enough.
What would make it easier is if we can display that filtered list in Confluence. I can use the Insert JIRA Issue/Filter macro, but the type and priority are icons and a custom field is not populating (though is does in Jira). If I copy the URL of the filtered list, it uses the default columns instead of my customized. Finally, I can take the Excel spread sheet and dump that in a Confluence page, with some additional formatting, and while I gain the type and priority text and even the custom field, I lose the link to the ticket.
It looks like you're new here. Sign in or register to get started.
