ITableFilterCondition.Value

Syntax

Value: Variant;

Description

The Value property determines a constraint value.

Comments

On setting the constraint in this property the type is determined and the constraint value for this type is converted.

Example

Executing the example requires a form with the Button1 button, the DataGrid component named DataGrid1 and the UiDataSource component that is a data source for DataGrid.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
    Var
        filter: ITableFilter;
        filterItem: ITableFilterItem;
        cond1, cond2: ITableFilterCondition;

    Begin
        filter := DataGrid1.TableFilter;
        filterItem := filter.Item(0);
        cond1 := filterItem.Conditions.Add;
        cond1.Condition := FilterCondition.Less;
        cond1.Value := 6;
        cond1.Relation := FilterRelation.And_;
        cond2 := filterItem.Conditions.Add;
        cond2.Condition := FilterCondition.More;
        cond2.Value := 2;
        filterItem.State := FilterItemState.Condition;
    End Sub Button1OnClick;

On clicking the Button1 button, the first column is filtered. Filtering is executed by 6 and 2 values.