Filtering expressions available for columns or when searching for subjects of interest will vary by datatype of the column, and not all expressions are relevant or available in all contexts.
In the following tables, the "Arguments" column indicates how many data values, if any, should be provided for comparison with the data being filtered.
Expression | Arguments | Example Usage | Description |
---|
Has Any Value | | | Returns all values, including null |
Is Blank | | | Returns blank values |
Is Not Blank | | | Returns non-blank values |
Equals | 1 | | Returns values matching the value provided |
Does Not Equal | 1 | | Returns non-matching values |
Is Greater Than | 1 | | Returns values greater than the provided value |
Is Less Than | 1 | | Returns values less than the provided value |
Is Greater Than or Equal To | 1 | | Returns values greater than or equal to the provided value |
Is Less Than or Equal To | 1 | | Returns values less than or equal to the provided value |
Contains | 1 | | Returns values containing a provided value |
Does Not Contain | 1 | | Returns values not containing the provided value |
Starts With | 1 | | Returns values which start with the provided value |
Does Not Start With | 1 | | Returns values which do not start with the provided value |
Between, Inclusive | 2, comma separated | -4,4 | Returns values between or matching two comma separated values provided |
Not Between, Exclusive | 2, comma separated | -4,4 | Returns values which are not between and do not match two comma separated values provided |
Equals One Of | 1 or more, semi-colon separated | a;b;c | Returns values matching any one of a semi-colon separated list |
Does Not Equal Any Of | 1 or more, semi-colon separated | a;b;c | Returns values not matching a semi-colon separated list |
Contains One Of | 1 or more, semi-colon separated | a;b;c | Returns values which contain any one of a semi-colon separated list |
Does Not Contain Any Of | 1 or more, semi-colon separated | a;b;c | Returns values which do not contain any of a semi-colon separated list |
|
Is In Subtree | 1 | | (Premium Feature) Returns values that are in the ontology hierarchy 'below' the selected concept |
Is Not In Subtree | 1 | | (Premium Feature) Returns values that are not in the ontology hierarchy 'below' the selected concept |
Boolean Filtering Expressions
Expressions available for data of type boolean (true/false values):
- Has Any Value
- Is Blank
- Is Not Blank
- Equals
- Does Not Equal
Date Filtering Expressions
Date and DateTime data can be filtered with the following expressions:
- Has Any Value
- Is Blank
- Is Not Blank
- Equals
- Does Not Equal
- Is Greater Than
- Is Less Than
- Is Greater Than or Equal To
- Is Less Than or Equal To
Numeric Filtering Expressions
Expressions available for data of any numeric type, including integers and double-precision numbers:
- Has Any Value
- Is Blank
- Is Not Blank
- Equals
- Does Not Equal
- Is Greater Than
- Is Less Than
- Is Greater Than or Equal To
- Is Less Than or Equal To
- Between, Inclusive
- Not Between, Exclusive
- Equals One Of
- Does Not Equal Any Of
String Filtering Expressions
String type data, including text and multi-line text data, can be filtered using the following expressions:
- Has Any Value
- Is Blank
- Is Not Blank
- Equals
- Does Not Equal
- Is Greater Than
- Is Less Than
- Is Greater Than or Equal To
- Is Less Than or Equal To
- Contains
- Does Not Contain
- Starts With
- Does Not Start With
- Between, Inclusive
- Not Between, Exclusive
- Equals One Of
- Does Not Equal Any Of
- Contains One Of
- Does Not Contain Any Of
Related Topics