[jira] [Created] (QPID-7165) Allow query results to be sorted and paginated

["Keith Wall (JIRA)" <ji...@apache.org>]

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: dev-unsubscribe@qpid.apache.org
For additional commands, e-mail: dev-help@qpid.apache.org