Export Event type from JIRA to CSV

Question

Hello,

I have to export event type from issues in order to calculate a rate of disturbance (issues added to sprint after its start or issues removed while the sprint is in progress).

How can I specify this criteria in my request to export in CSV ?

Best regards,

Christophe CHALIGNE

unknown · Answer

The easiest way to get data from the Reports Burndown Chart is to just copy all the columns and paste it in a spreadsheet. It copies everything including the hyperlinks, as good as exporting the Burndown chart itself. :)

unknown · Answer

Hi Guy, this did not work for me. Not sure what am I doing wrong! JavaScript function is not getting added to the URL field on bookmarks. It throws invalid url.

Guy Mograbi · Answer

* Create a new bookmark on your chrome. 
* Set its name to "download burndown data"
* Change the URL of the bookmark to

javascript&colon;(function(){
var csv = $('table.aui tr').toArray().slice(3).map((row) => $(row).find('td').map((index, cell) => $(cell).text()).toArray().join(',')).join('
');
csv = 'data&colon;text/csv;charset=utf-8,' + csv;
data = encodeURI(csv);
link = document.createElement('a');
link.setAttribute('href', data);
link.setAttribute('download', 'data.csv');
link.click(); 
})()

* Open your burndown page with the table that you want to export. 
* Click the bookmark.

You should see a download prompt with the data.

Tested on Chrome and Jira Cloud.

Might break between different Jira versions.

Enjoy.