Download more than 3000 issues at a time excel file

[DeepakBhatia]

Hi,

I have 4700 issues in my project in JIRA.

I am facing two problems

1. When I list all the issues in issue navigator, it displays 1000 issues. But I can download 3000 at a time.

2. When I goto to issue 3001 to 4700, it agains downloads from 1 to 3000.

How can I download all the 4700 issues at a time ?

Thanks

Deepak Bhatia

[parthiban subramaniam]

Have a look at here and make the necessary modification for your version

https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel

[DeepakBhatia]

Hi Parthis,

I am getting following error

Access to the specified resource (You are not allowed to get a result set of more than 3000 results. Current search returns 4702 results) has been forbidden.

Regards

Deepak Bhatia

[parthiban subramaniam]

You need to grant permissions as well like so

jira.search.views.max.unlimited.group = jira-administrators

this should go in a file called jira-config.properties under jira.home

if you dont see a file there create one and add this property

[DeepakBhatia]

I am updating the jira-config.properties with

jira.search.views.default.max = 6000

jira.search.views.max.limit = 6000

[DeepakBhatia]

Thanks, you mean if I set

jira.search.views.max.unlimited.group = jira-administrators

Then only JIRA Administrator will be able to view maximum

[DeepakBhatia]

My new jira-config file has following values

jira.search.views.default.max = 6000
jira.search.views.max.limit = 6000
jira.search.views.max.unlimited.group = jira-users

As we have users who mostly access JIRA from LAN....Please confirm, Thanks....

[parthiban subramaniam]

looks good .. dont forget to restart .. a word of caution .. this is not a default for a reason and might affect your performance.. use it with care

[Nic Brough -Adaptavist-]

To echo Parthis' warning - downloads of more than a couple of thousand issues WILL kill your performance if you do them a lot. If it's irregular and only one or two people do it, you'll be fine, but if 30 people all run similar large downloads at 2pm on a Thursday because it's a meeting time, you will find the server grinds to a halt.

It's always worth questioning people doing large downloads - it usually means they need training, help or that they've got a broken business requirement. In some rare cases, they actually need some code to help them.