Predefined filter expression enumeration. Used by GridFilterFunction class.
Some functions are applicable (and are not displayed on filterting) to all the data types:
String type supports all the functions.
Integer: NoFilter, EqualTo, NotEqualTo, GreaterThan, LessThan, GreaterThanOrEqualTo, LessThanOrEqualTo, Between, NotBetween, IsNull and NotIsNull are supported. Contains, DoesNotContain, StartsWith, EndsWith, IsEmpty and NotIsEmpty are not supported.
Date: same as Integer.
Definition
Fields
Same as: value1 <= dataField <= value2.
Note that value1 and value2 should be separated by [space] when entered as
filter.
Between = 11Same as: dataField LIKE '/%value/%'
Contains = 1Custom function will be applied. The filter value should contain a valid filter expression, including DataField, operators and value
Custom = 17Same as: dataField NOT LIKE '/%value/%'
DoesNotContain = 2Same as: dataField LIKE '/%value'
EndsWith = 4Same as: dataField = value
EqualTo = 5Same as: dataField > value
GreaterThan = 7Same as: dataField >= value
GreaterThanOrEqualTo = 9Same as: dataField = ''
IsEmpty = 13Only null values
IsNull = 15Same as: dataField < value
LessThan = 8Same as: dataField <= value
LessThanOrEqualTo = 10No filter would be applied, filter controls would be cleared
NoFilter = 0Same as: dataField <= value1 && dataField >= value2.
Note that value1 and value2 should be separated by [space] when entered as
filter.
NotBetween = 12Same as: dataField != value
NotEqualTo = 6Same as: dataField != ''
NotIsEmpty = 14Only those records that does not contain null values within the corresponding column
NotIsNull = 16Same as: dataField LIKE 'value/%'
StartsWith = 3