increase max jira search results

[Antigone K]

This question is in reference to Atlassian Documentation: Exporting Search Results to Microsoft Excel

I need to show ALL issues in an export, which is currently about 13000 issues, but the JQL filter is limited to 1000 returns. how do I show ALL issues? thanks!

[Deleted user · Accepted solution]

If you're up against a deadline and don't have time to learn any better approach, just split the report. Use Project not in () to remove a few of the largest projects, then Project in () to get only those. Export both results and then merge them in Excel.

[Deleted user]

Follow this doc:

https://confluence.atlassian.com/jirakb/exporting-a-filter-result-containing-more-than-1000-issues-191500982.html

[Nic Brough -Adaptavist-]

Bear in mind that the limit is there for a very good reason - large exports damage performance and can even crash it.  If anything, it's worth reducing the limit to discourage people breaking stuff.

It's a far better approach to look at why you want to do a huge export - there's almost always going to be a much better solution to what you're trying to do.

[Antigone K]

I'd love to know what these other solutions are then!

basically we need a report of all issues, their types, project, and dates created and resolved so that we can graph out the number of specific issue types (specifically bugs) as a percentage of the project's workload, and how long, on average, each issue type takes to resolve.

[Nic Brough -Adaptavist-]

Dashboard gadgets can answer most of those.  Failing that, there's plenty of reporting add-ons which will tell you.  (Also bear in mind that around 90% of spreadsheets tend to be basically wrong)

[Antigone K]

ty! I'll look into those for next time as our immediate need is, uh, more immediate than a plug-in can be tested and installed for us.

[MattS]

Also JIRA agile boards have some useful control chart reports

[Antigone K]

thanks! my skills aren't quite up to snuff for 13,000 issues across more than 100 projects though.

:: sigh :: time for a crash course!