qpid-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Keith Wall (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (QPID-7165) Allow query results to be sorted and paginated
Date Thu, 31 Mar 2016 15:40:25 GMT

    [ https://issues.apache.org/jira/browse/QPID-7165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15220054#comment-15220054
] 

Keith Wall commented on QPID-7165:
----------------------------------

We want to check the relevant SQL standards concerning the syntax for the sorting of a column
that results from function/expressions and follow it if possible.

For limit/offset, it seems there is not a broad consensus in the REST implementing community
regarding the correctness of the use of Range headers to implement pagination.  We said we
would go we limit and offset query parameters for now, and revisit the decision. Also when
limit is returned the number of records that would be returned if pagination were not in use
must be returned as part of the response.



> Allow query results to be sorted and paginated
> ----------------------------------------------
>
>                 Key: QPID-7165
>                 URL: https://issues.apache.org/jira/browse/QPID-7165
>             Project: Qpid
>          Issue Type: New Feature
>          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 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.



--
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


Mime
View raw message