TcxFilterOperatorKind Enum
Enumerates filter condition operators.
#Declaration
TcxFilterOperatorKind = (
foEqual,
foNotEqual,
foLess,
foLessEqual,
foGreater,
foGreaterEqual,
foLike,
foNotLike,
foBetween,
foNotBetween,
foInList,
foNotInList,
foYesterday,
foToday,
foTomorrow,
foLast7Days,
foLastWeek,
foLast14Days,
foLastTwoWeeks,
foLast30Days,
foLastMonth,
foLastYear,
foInPast,
foThisWeek,
foThisMonth,
foThisYear,
foNext7Days,
foNextWeek,
foNext14Days,
foNextTwoWeeks,
foNext30Days,
foNextMonth,
foNextYear,
foInFuture,
foContains,
foNotContains,
foBeginsWith,
foEndsWith
);
#Members
Name |
---|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
fo
|
#Remarks
This type enumerates operators used in a simple filter condition of the TcxFilterCriteriaItem class. A simple filter condition consists of a single comparison operation. The operator for the comparison operation is provided by the TcxFilterCriteriaItem.OperatorKind property. The item values are compared according to the TcxFilterCriteriaItem.Value property.
Comparison operators check whether two expressions match. The following table lists possible operators:
Value | Description |
---|---|
fo | The = operator Equal to |
fo | The <> operator Not equal to |
fo | The < operator Less than |
fo | The <= operator Less than or equal to |
fo | The > operator Greater than |
fo | The >= operator Greater than or equal to |
fo | The LIKE operator 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 another characters to be used as wildcards via the Tcx For instance, the operator “LIKE ‘Mc%’ “ returns true for all strings that begin with the letters ‘Mc’ and contain any number of characters. |
fo | The ‘NOT LIKE’ operator TRUE if the operand does not match a pattern. See the description of the fo |
fo | The BETWEEN operator TRUE if the operand is between two inclusive values. These values are specified as an array of variants using the Tcx To create the variant array, you can use the Var |
fo | The negation of the BETWEEN operator TRUE if the operand does not belong to a range. The bounds of the range are specified by the Tcx Refer to the example provided for the fo |
fo | The IN (also called ‘membership test’) operator TRUE if the operand is in the value list provided by the Tcx |
fo | The negation of the fo TRUE if the operand is not a member of the value list provided by the Tcx Refer to the example provided for the fo |
fo | Applies to date values. TRUE if the operand is equal to yesterday’s date. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand is equal to the current date. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand is equal to tomorrow’s date. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the last seven days. By default, today’s date is included into the range as specified by the cx The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the previous week. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the last fourteen days. By default, today’s date is included into the range as specified by the cx The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the previous two weeks. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the last thirty days. By default, today’s date is included into the range as specified by the cx The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the previous month. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the previous year. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the past dates. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the current week. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the current month. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the current year. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next seven days. By default, today’s date is included into the range as specified by the cx The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next week. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next fourteen days. By default, today’s date is included into the range as specified by the cx The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next two weeks. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next thirty days. By default, today’s date is included into the range as specified by the cx The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next month. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the next year. The value and display text provided by the Tcx |
fo | Applies to date values. TRUE if the operand falls within the future dates. The value and display text provided by the Tcx |
fo | The CONTAINS operator Applies to string values TRUE if the operand contains a specified substring. The wildcards specified by the Tcx |
fo | The ‘NOT CONTAINS’ operator Applies to string values TRUE if the operand doesn’t contain a specified substring. The wildcards specified by the Tcx |
fo | The ‘BEGINS WITH’ operator Applies to string values TRUE if the operand begins with a specified substring. The wildcards specified by the Tcx |
fo | The ‘ENDS WITH’ operator Applies to string values TRUE if the operand ends with a specified substring. The wildcards specified by the Tcx |