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 3 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 One
     http://{host}/rds/{collection}/{view}/select?where=VAR1>=1
    Where VAR1 is Greater Than One
     http://{host}/rds/{collection}/{view}/select?where=VAR1>1
    Where VAR1 is Equal to One
     http://{host}/rds/{collection}/{view}/select?where=VAR1=1
    Where VAR1 is Less Than One
     http://{host}/rds/{collection}/{view}/select?where=VAR1<1
    Where VAR1 is Less Than or Equal to One
     http://{host}/rds/{collection}/{view}/select?where=VAR1<=1
    Where VAR1 Starts With One
     http://{host}/rds/{collection}/{view}/select?where=VAR1 like '1%25'
    Where VAR1 is Matches a Two Digit Number Starting With One
     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 One and VAR2 Does Not Equal One or VAR3 Equals Two
      http://{host}/rds/{collection}/{view}/select?where=(VAR1=1 AND VAR2!=1) OR VAR3=2
  • No labels