PFQueryFilterOperator Enumeration |
Namespace: Packflow.Core
[DataContractAttribute] public enum PFQueryFilterOperator
Member name | Value | Description | |
---|---|---|---|
Equal | 0 | Checks if the column value is equal to a given value. | |
NotEqual | 1 | Checks if the column value is different to a given value. Attention to the NULL case: NULL!='test' will return false. You should add another filter with IsNull or IsNotNull to handle this case. Another option is the COALESCE feature available for Packflow filters. http://www.xaprb.com/blog/2006/05/18/why-null-never-compares-false-to-anything-in-sql/ | |
Greater | 2 | Checks if the column value is greater than a given value. | |
GreaterOrEqual | 3 | Checks if the column value is greater or equal than a given value. | |
Less | 4 | Checks if the column value is less than a given value. | |
LessOrEqual | 5 | Checks if the column value is less or equal than a given value. | |
BeginsWith | 6 | Checks if the column value starts with a given value. | |
EndsWith | 7 | Checks if the column value ends with a given value. | |
Contains | 8 | Checks if the column value contains a given value. | |
NotContains | 9 | Checks if the column value does not contain a given value. | |
IsNull | 10 | Checks if the column value is null or empty. | |
IsNotNull | 11 | Checks if the column value is not null or empty. |