Reporting on Jira SD tickets

[Rob]

I am trying to pull a report on the year's ticket activity to an excel spreadsheet. It appears that I can only get a format that will allow for links for the ticket totals for each month that dont transfer to excel (except for totals) Is anyone able to pull bulk raw data?

[Jack Brickey · Accepted solution]

Your question is a bit confusing.

if you want to export all issues created since the beginning of the year use this JQL...

createddate >= startofyear()

then use the esport function to push to CSV

[Rob]

Sorry about the confusion (coffee hasn't quite kicked in yet). I used your JQL which will provide all the tickets in the year...but when downloaded to CSV i just get the totals per month and not the actual ticket information so I can filter out unwanted data from the report.

[Jack Brickey]

That really makes no sense. What you should get is a row for every issue including either the fields displayed based on query or all fields depending on the e port option you chose. 

Are you on cloud or server? Can you provide a screenshot of you query results and the excel view?

[Rob]

We are on the cloud...I would agree with you on that is what I like to get but this is what I do get. Here is the pics...thanks in advance for you help

[Jack Brickey]

ok so I don't think you are using the export from the advanced search for issues. please do the following:

• click on magnifying on blue sidebar
• click on advanced search issues
• ensure you are in advanced (JQL) mode
• enter the filter I provided
• click on the export (box w/ arrow pointing down) at the top once results are shown
• choose either current fields or all fields

[Rob]

I see said the blind man...I was using reporting section of Jira SD...this now works. Thank you for your help