Feature #1315
Sorting and limiting the List method
Status:
Closed
Priority:
Normal
Assignee:
Elmer de Looff
Category:
Model
Target version:
-
Start date:
2012-12-18
Due date:
% Done:
100%
Estimated time:
Description
We need a way to sort the results from the List method.
Also, a limit + offset so that pagination can be achieved.
Thirdly, and optionally, return the unlimited count of rows that would be returned if the LIMIT statement had not been applied to the query.
See: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows for this last function.
Associated revisions
History
#1 Updated by Elmer de Looff almost 12 years ago
- Subject changed from Sorting and limiting on the List method to Sorting and limiting the List method
- Description updated (diff)
#2 Updated by Elmer de Looff almost 12 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 70
Applied in changeset 62121196ef2f.
#3 Updated by Elmer de Looff almost 12 years ago
- Status changed from Resolved to Closed
- % Done changed from 70 to 100
Exposed limits and offsets on the Record.List method. Also a flag that causes the List method to yield the total count as the first item. This resolves #1315.