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 values, either semicolon or new line separated	a;b;c a b c	Returns values matching any one of the values provided
Does Not Equal Any Of	1 or more values, either semicolon or new line separated	a;b;c a b c	Returns values not matching a provided list
Contains One Of	1 or more values, either semicolon or new line separated	a;b;c a b c	Returns values which contain any one of a provided list
Does Not Contain Any Of	1 or more values, either semicolon or new line separated	a;b;c a b c	Returns values which do not contain any of a provided 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

• Filter Data
• Ontology Column Filtering (Premium Feature)