TcxFilterControlOperators Type

A set of comparison operators used in constructing filter conditions.

Declaration

TcxFilterControlOperators = set of TcxFilterControlOperator;

Referenced Class

Type
TcxFilterControlOperator

Remarks

A simple filter condition consists of a single comparison operation. The TcxFilterControlOperator type enumerates comparison operators available for this condition. The TcxFilterControlOperators type simply combines all these operators in a set which is used to populate a filter control’s dropdown list with comparison operators.

The values contained in the set are described below:

Value	Description
fcoNone	No operator is specified for a filter condition.
fcoEqual	Operator ‘=’ Equal to
fcoNotEqual	Operator ‘<>’ Not equal to
fcoLess	Operator ‘<’ Less than
fcoLessEqual	Operator ‘<=’ Less than or equal to
fcoGreater	Operator ‘>’ Greater than
fcoGreaterEqual	Operator ‘>=’ Greater than or equal to
fcoLike	Operator ‘LIKE’ TRUE if the operand matches a pattern. With the LIKE operator you can use ‘%’ and ‘‘ wildcards. The ‘%’ wildcard substitutes any number of characters. The ‘‘ character is used to represent any single character. You can assign other characters to be used as wildcards via the PercentWildcard and UnderscoreWildcard properties. For instance, the operator “LIKE ‘Mc%’ “ returns TRUE for all strings that begin with the letters ‘Mc’ and contain any number of characters.
fcoNotLike	Operator ‘NOT LIKE’ TRUE if the operand does not match a pattern. See the description of the fcoLike value.
fcoBlanks	Checks whether the tested value is the NULL value (using the IS NULL or = NULL clauses) or an empty string value (using the =’’ clause). Use the SoftNull property to specify whether empty strings are considered as NULL values or empty string values (‘’) when comparing.
fcoNonBlanks	Checks whether the tested value is not the NULL value (using the IS NOT NULL or <> NULL clauses) or an empty string value (using the <>’’ clause). Use the SoftNull property to specify whether empty strings are considered as NULL values or empty string values (‘’) when comparing.
fcoBetween	Operator ‘BETWEEN’ TRUE if the operand is between two values inclusively.
fcoNotBetween	The negation of the ‘BETWEEN’ operator TRUE if the operand does not belong within a range.
fcoInList	The membership test operator. TRUE if the operand is in the list of specific values.
fcoNotInList	The negation of the fcoInList operator. TRUE if the operand is not a member of the value list.
fcoYesterday	Applied to date values. TRUE if the operand is equal to yesterday’s date.
fcoToday	Applied to date values. TRUE if the operand is equal to the current date.
fcoTomorrow	Applied to date values. TRUE if the operand is equal to tomorrow’s date.
fcoLast7Days	Applied to date values. TRUE if the operand falls within the last seven days.
fcoLastWeek	Applied to date values. TRUE if the operand falls within the previous week.
fcoLast14Days	Applied to date values. TRUE if the operand falls within the last fourteen days.
fcoLastTwoWeeks	Applied to date values. TRUE if the operand falls within the previous two weeks.
fcoLast30Days	Applied to date values. TRUE if the operand falls within the last thirty days.
fcoLastMonth	Applied to date values. TRUE if the operand falls within the previous month.
fcoLastYear	Applied to date values. TRUE if the operand falls within the previous year.
fcoInPast	Applied to date values. TRUE if the operand falls within the past dates.
fcoThisWeek	Applied to date values. TRUE if the operand falls within the current week.
fcoThisMonth	Applied to date values. TRUE if the operand falls within the current month.
fcoThisYear	Applied to date values. TRUE if the operand falls within the current year.
fcoNext7Days	Applied to date values. TRUE if the operand falls within the next seven days.
fcoNextWeek	Applied to date values. TRUE if the operand falls within the next week.
fcoNext14Days	Applied to date values. TRUE if the operand falls within the next fourteen days.
fcoNextTwoWeeks	Applied to date values. TRUE if the operand falls within the next two weeks.
fcoNext30Days	Applied to date values. TRUE if the operand falls within the next thirty days.
fcoNextMonth	Applied to date values. TRUE if the operand falls within the next month.
fcoNextYear	Applied to date values. TRUE if the operand falls within the next year.
fcoInFuture	Applied to date values. TRUE if the operand falls within the future dates.