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

Overview

In addition to variable subsetting, RDS also supports comprehensive and complex record subsetting. This is done though the where parameter. The where clause is similar to that of a relational database where users can specify logical operations that will be evaluated to subset the data set.

Supported Where Functions

NameOperator
Greater than or equal to>=
Greater than>
Equal to=
Less than<
Less than or equal to<=
Not equal to!=
Like a particular valuelike
Matches a regular expressionmatches

On this page:

Step By Step

Simple Where Clauses

  • Users may specify a where clause to filter the records as follows. 

    Where VAR1 is Greater Than or Equal to 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1>=1
    Where VAR1 is Greater Than 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1>1
    Where VAR1 is Equal to 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1=1
    Where VAR1 is Less Than 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1<1
    Where VAR1 is Less Than or Equal to 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1<=1
    Where VAR1 is Not Equal to 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1!=1
    Where VAR1 Starts With 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1 like '1%25'
    Where VAR1 is Matches a Two Digit Number Starting With 1
     http://{host}/rds/{collection}/{view}/select?where=VAR1 matches '[1][0-9]'

Where Clauses With Logical Operators

  • Individual filtering parameters can be combined with logical operators AND or OR. 

    Where VAR1 Equals 1 and VAR2 Does Not Equal 1 or VAR3 Equals 2
      http://{host}/rds/{collection}/{view}/select?where=(VAR1=1 AND VAR2!=1) OR VAR3=2
  • No labels