IUiDataSet.Filter

Syntax

Filter: String;

Description

The Filter property determines text of the current data set filter. When filtering of a data set is on, only records that meet filtering conditions become available.

Example

Executing the example requires a form with the Button1 button, the UiTable component named UiTable1 and any components that display table data. A repository table, to which UiTable1 is connected, contains the Id field.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);

Begin

UiTable1.Filter := "(Id>=10)And(Id<=50)";

UiTable1.Filtered := True;

End Sub Button1OnClick;

After executing the example, pressing the button filters table data by the Id field. Only the records, for which the Id field value is in the [10,50] range, are available.