Obtain all issues via URL/Link (I can only get 1000 in each report)

Can I obtain all open/closed/resolved/etc. issues via URL for the past year (from the current date)?

http://<MY JIRA SERVER>/sr/jira.issueviews:searchrequest-excel-all-fields/10064/SearchRequest-10064.xls?

I can't use the above link, but this one works to get the last 1000 that were opened:

http://<MY JIRA SERVER>/sr/jira.issueviews:searchrequest-excel-all-fields/10064/SearchRequest-10064.xls?tempMax=1000

I'm not certain how to grab all hosts, and how to specify that they were only from the last year.

1 answer

1 accepted

Accepted Answer
1 vote

You seem to have answered your own question.

You might also want to try looking at the variety of "views" on the issue navigator - especially the XML view, or possibly RSS

I forgot to mention, it doesn't let me put anything higher than 1000 for tempMax, and I don't there there is an "all" variable for that either.

So if you change that url to include (say) tempmax=5000 instead, it stops you? That's a deliberate block by your Jira administrators, to prevent you overloading the system with top-heavy downloads.

Have you tried improving your filter request? All you've got here is a saved filter, you don't explain what's in it - I'd certainly be starting with "created > -365d"

Yes, that is also blocked. I'm assuming by limit that is placed. I've added jira-config.properties to the JIRA_HOME folder, and added jira.search.views.max.limit = 10000

Hopefully this works, but I need to figure out how to restart JIRA first (on windows)

Sorry, what is also blocked? If you can see those urls, you have a login, and if you can log in, you can create filters, and run your own, better, searches. Unless it's got anonymous enabled.

Please remember that those limits were probably implemented because running large reports can kill your server. The limits are off by default, so someone on your server has done it deliberately, to prevent overloads.

Either way, I seriously suggest you talk to your admins about why it's set up this way and how better to answer your questions about the data.

I've been given permission to modify the file to increase the maximum. I've added the config file at C:\Program Files\Atlassian\Application Data\JIRA\jira-config.properties, and added the line java.search.views.max.limit = 10000 (I will decrease this after I confirm it works), and rebooted the service; and it has worked. The temp max (when anyone normally gets reports) gets only 1000, but will allow more if specified in the URL.

Ok, Just remember that this is the first thing to look for when you have performance issues.

I'll make a note, thanks!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

29 views 0 2
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you