TcxFilterCriteria.FilterText Property

Specifies filter criteria for a grid control.

Declaration

property FilterText: string read; write;

Property Value

Type
string

Remarks

When filtering is applied to a grid, only nodes that meet filter conditions are displayed. The FilterText property contains a string that describes filter conditions. Unlike the FilterCaption property, the FilterText property value can be applied to a dataset or an SQL statement. That is why the FilterText property uses the wildcards specified by the PercentWildcard and UnderscoreWildcard properties to convert the CONTAINS, ‘NOT CONTAINS’, ‘BEGINS WITH’, and ‘ENDS WITH’ operators to LIKE operator equivalents.

FilterCaption (State = CA) AND (PurchaseDate = 01-Mar-1976)

FilterText (State = ‘CA’) AND (PurchaseDate = ‘01-Mar-1976’)