Export More Than 1000 Results to Excel (ON demand subscription)

I have read the article below; but the managers who is using this system wants too many reports. I dont have much time to export 1000 rows and consolidate them at the end. I need a permanent solution, can't you customize my cloud instance export limit to 20000?

2 answers

1 accepted

Well the problem here is that you don't know what your managers want. Nobody will look at list with 20000 issues. They will filter these list again to get what ever shorter list. And this is what you need to find out. Talk to them in order to get their real requirements.

Show them what you can do with dashboards and all available gadgets. Point out all the benefit they would have to see everything in one single dashboard. I bet for any requirements from your managers you can find a solution. So you will save your time and the managers as well.

There are two ways you can get this out:
1. Break up your query into smaller parts (a pain to run many downloads and stitch them together)
2. Download the xml and parse it for the issues you need (a pain to parse out your issues)
A far better approach is to reexamine your reporting requirements. Reports based on 20,000 issues are almost universally useless, you want summaries, not the issues, and those summaries are mostly available in JIRA. Perhaps if you explained them to us, we could point you at something that you can do.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

You can use getIssueList from JIRA Command Line Interface (CLI) to produce a CSV file which can be imported into Excel. The data is retrieved in small chunks, so it avoids the JIRA limit. For very large queries, you just need to make sure the client JVM has sufficient memory.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.