Page Comparison

...

• Begin with a simple select query.

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

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

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

  Code Block
  title 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. 

  Code Block
  title Order by VAR1 Descending and VAR2 Ascending
  http://{host}/rds/{collection}/{view}/select?orderby=VAR1 DESC,VAR2 ASC