[QPID-7165] Allow query results to be sorted and paginated

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: qpid-java-6.1
• Component/s: Broker-J
• Assignee: Unassigned
• Reporter: Keith Wall
• Created: 29/Mar/16 14:12
• Updated: 17/Nov/16 13:04
• Resolved: 31/May/16 13:16

Description

Extend the mechanism provided by QPID-6969 to allow for the results set to be sorted by one or more columns and results set to be paginated.

For the ordering clause, we could use SQL:2011 ORDER BY clause as a guide e.g. orderBy='x ASC,y DESC,z'

For the pagination, SQL standardisation does not include it. https://en.wikipedia.org/wiki/Select_%28SQL%29#Result_limits We could opt for limit= offset= like MySQL/Sybase. We could also consider HTTP Range headers.