Click or drag to resize

PFQueryFilterOperator Enumeration

Identifies an operator used in a PFQuery filter.

Namespace:  Packflow.Core
Assembly:  MicaSystems.Packflow.Core (in MicaSystems.Packflow.Core.dll) Version: 1.0.0.0 (3.2.0.306)
Syntax
C#
[DataContractAttribute]
public enum PFQueryFilterOperator
Members
  Member nameValueDescription
Equal0 Checks if the column value is equal to a given value.
NotEqual1

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/

Greater2 Checks if the column value is greater than a given value.
GreaterOrEqual3 Checks if the column value is greater or equal than a given value.
Less4 Checks if the column value is less than a given value.
LessOrEqual5 Checks if the column value is less or equal than a given value.
BeginsWith6 Checks if the column value starts with a given value.
EndsWith7 Checks if the column value ends with a given value.
Contains8 Checks if the column value contains a given value.
NotContains9 Checks if the column value does not contain a given value.
IsNull10 Checks if the column value is null or empty.
IsNotNull11 Checks if the column value is not null or empty.
See Also