Keith Wall created QPID-7165:
--------------------------------
Summary: Allow query results to be sorted and paginated
Key: QPID-7165
URL: https://issues.apache.org/jira/browse/QPID-7165
Project: Qpid
Issue Type: Bug
Components: Java Broker
Reporter: Keith Wall
Fix For: qpid-java-6.1
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
{{orderBy='x,y,z'}} and orderDirection=ASC|DESC.
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
