TTdbDataSet.Filter
TTdbDataSet

Contains an expression used for filtering the records of the data set.

property Filter: string;

Description
TurboDB supports two kinds of filters, conditional filters and keyword filters. Conditional filters work with a logical condition and show all records satisfying this condition. Conditions are described in "Search-Conditions". Set FilterType to tftCondition to use a conditional filter.

Keyword filters need a full-text index to work. If a full-text index is available, keyword filters show all records containing a given set of keywords. In this case the filter is just a comma-separated list of keywords. Set FilterType to tftKeywords to use a keyword filter.