Feature #5286

Need a way to load all issues in 1 web request, not just 25/50/100

Added by Alex Last over 11 years ago. Updated almost 9 years ago.

Status:ReopenedStart date:2010-04-09
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution:Invalid

Description

I'm trying to use Excel<-Redmine import feature I described in task #5284.
Another problem I see is that "# of issues per page" parameter is not saved in user settings and also can't be more than 100.
I tried query
http://&lt;server&gt;/projects/&lt;my_proj&gt;/issues?per_page=5000&query_id=229
but it seems all "per_page" values are ignored except for "25, 50, 100".

As the result, the Excel<-Redmine import can only load and automatically update first 25/50/100 rows while I need to see ALL tasks there.

I know I can export issues from redmine to a CSV file, but this is less convenient for automatic updates for the imported data in Excel.

I understand a heavy query can add some load to the server, but I don't think this is a big issue in my circumstances.

Any help?

History

#1 Updated by Henrik Ammer over 11 years ago

Check your Redmine settings. In your Settings -> General you have the "Objects per page options" where you can add your own definition. By adding (for instance) 5000 there would make you able to get that many results into Excel.

#2 Updated by Jean-Philippe Lang over 11 years ago

  • Status changed from New to Closed
  • Resolution set to Invalid

Indeed.

#3 Updated by Alex Last over 11 years ago

Thanks, guys. I didn't know that.

#4 Updated by Nikolay Kotlyarov over 11 years ago

  • Status changed from Closed to Reopened

Need a way to load all issues in 1 web request, not just 25/50/100/any_other_finite_number

Could it be possible to add "all" option?
There could be a checkbox to enable that or something like:

Objects per page options: 25, 50, 100, 200, all
                          Multiple values and string "all" allowed (comma separated)

Changing "Objects per page" maximum value is a workaround and doing this whenever someone needs a bigger max-value(issues quantity grows through time) implies that he must contact redmine admin.

#5 Updated by Felix Schäfer over 11 years ago

I haven't used REST APIs much, but I have yet to stumble across one that didn't paginate… Any particular reason you aren't happy with the paginated results other than "oh god I have to make more than one request that's too complicated :-O"?

#6 Updated by Nikolay Kotlyarov over 11 years ago

Felix Schäfer wrote:

I haven't used REST APIs much, but I have yet to stumble across one that didn't paginate… Any particular reason you aren't happy with the paginated results other than "oh god I have to make more than one request that's too complicated :-O"?

you're right, i am just lazy:)

But it is not for REST API, i'm talking about browser view:
for example a manager wants to see some statistics, he configures filters, grouping and columns as he need and.. he can not see results in one place because of limited issues per page.

#7 Updated by Alex Last over 11 years ago

I think this request's priority can be set to "LOW".

#8 Updated by Jan Niggemann (redmine.org team member) almost 9 years ago

Closing this as it's old and has no feedback since 2 years.

Also available in: Atom PDF