Defines the type of filter applies to a column.
Use the
FilterType property of the
Column
object to specify the type of filter being used. Use the
Filter
property of Column object to specify the filter being used. The value for
Filter property depends on the FilterType property.
| |  | Name | Value | Description | |
| | |
exAll | 0
|
No filter applied
| |
| | |
exBlanks | 1
|
Only blank items are included
| |
| | |
exNonBlanks | 2
|
Only non blanks items are included
| |
| | |
exPattern | 3
|
Only items that match the pattern are included. The Filter property defines the
pattern. A pattern may contain the wild card characters '?' for any single
character, '*' for zero or more occurrences of any character, '#' for any digit
character. If any of the *, ?, # or | characters are preceded by a \
( escape character ) it masks the character itself.
| |
| | |
exDate | 4
|
Use the exDate type to filter items into a given interval. The Filter property
of the Column object defines the interval of dates being used to filter items.
The interval of dates should be as [dateFrom] to [dateTo]. Use the Description
property to changes the "to" conjunction used to split the dates in
the interval. If the dateFrom value is missing, the control includes only the
items before the dateTo date, if the dateTo value is missing, the control
includes the items after the dateFrom date. If both dates ( dateFrom and dateTo
) are present, the control includes the items between this interval of dates.
For instance, the "2/13/2004 to" includes all items after 2/13/2004
inclusive, or "2/13/2004 to Feb 14 2005" includes all items between
2/13/2004 and 2/14/2004.
| |
| | |
exNumeric | 5
|
If the FilterType property is exNumeric, the Filter property may include
operators like <, <=, =, <>, >= or > and numbers to define
rules to include numbers in the control's list. For instance, the
"> 10 < 100" filter indicates all numbers greater than 10 and
less than 100.
| |
| | |
exCheck | 6
|
Only checked or unchecked items are included. The CellState
property indicates the state of the cell's checkbox. The control filters for
checked items, if the Filter property is
"1". The control filters for unchecked items, if the Filter
property is "0". A checked item has the the CellState property
different than zero. An unchecked item has the CellState property on zero.
| |
| | |
exImage | 10
|
Filters items by icons. The CellImage property
indicates the cell's icon.
| |
| | |
exFilter | 240
|
Only the items that are in the Filter property are included.
| |
