[Overview][Constants][Types][Classes][Procedures and functions][Variables][Index] | Reference for unit 'DB' (#fcl)

# TDataSet.Filter

Filter to apply to the data in memory.

## Declaration

Source position: db.pas line 1741

`public property TDataSet.Filter : string read FFilterText write SetFilterText;`

## Description

Filter is not implemented by TDataset. It is up to descendent classes to implement actual filtering: the filtering happens on in-memory data, and is not applied on the database level. (in particular: setting the filter property will in no way influence the WHERE clause of an SQL-based dataset).

In general, the filter property accepts a SQL-like syntax usually encountered in the WHERE clause of an SQL SELECT statement.

The filter is only applied if the Filtered property is set to True. If the Filtered property is False, the Filter property is ignored.

## See also

TDataset.Filtered |  | Is the filter active or not.
TDataset.FilterOptions |  | Options to apply when filtering