Project

General

Profile

Feature #7427

Add pagination to browser queries

Added by Robert Illingworth about 5 years ago. Updated over 4 years ago.

Status:
Assigned
Priority:
Normal
Assignee:
Michael Gheith
Target version:
-
Start date:
12/04/2014
Due date:
% Done:

0%

Estimated time:
Duration:

Description

Some of the browser queries can potentially return a large result set. So add the ability to limit the results to a reasonable number, and add paging through them.

History

#1 Updated by Robert Illingworth about 5 years ago

  • Status changed from New to Assigned

5257e3d adds limit and after_id parameters to the project list query. The latter will return rows where the project_id is greater than the given value; this is more efficient than using offset as the DB can jump over the indexed column rather than having to count through and discard so many rows. Using either of these parameter also add an "order by project_id" clause to the query, so it will return consistent results.

#2 Updated by Robert Illingworth almost 5 years ago

  • Target version changed from 2.2 to 2.3

#3 Updated by Robert Illingworth over 4 years ago

  • Target version deleted (2.3)


Also available in: Atom PDF