Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 5 Current »

Overview

The select function also allows users to order results the way they might in a typical relational database. Results may be ordered by one or more variables in both ascending or descending order.

Order Results

  • If ascending or descending order is not specified the order by clause will default to ascending. 

    Order by VAR1 Ascending
    http://{host}/rds/{collection}/{view}/select?orderby=VAR1

  • To specify descending order add "DESC" to the clause. 

    Order by VAR1 Descending
    http://{host}/rds/{collection}/{view}/select?orderby=VAR1 DESC

  • Ordering by multiple variables is possible though separating the variables and their order by a comma. 

    Order by VAR1 Descending and VAR2 Ascending
    http://{host}/rds/{collection}/{view}/select?orderby=VAR1 DESC,VAR2 ASC
  • No labels