property Filter: String;
Description
Use Filter property to set dataset filter. When filtering is active, Filter specifies the condition which determines the records which are visible for the application. Filter can be set as Delphi logical condition, xHarbour logical condition or SQL condition (Mediator only). To learn how to set xHarbour filter refer to TranslateFilter property. Setting SQL filter is accomplished using SQLFilter property.
Delphi logical condition may only contain logical operators, field-value comparisons and parentheses. Wildcards are not allowed. Use single quotes to mark string literals.
Example:
products.Filter := 'ProdClass='+QuotedStr('F'); // set filter condition
products.Filtered := true; // activate filtering