フィルタ式

The FilterEditor allows end-users to create complex filter criteria by adding filter combinations and operations as nodes. The TreeView based filtering UI can be attached to any control or information screen. For every operation, the control shows drop-down menu with available options.

Filter Combination

You can create complex filter expressions by adding logical filter combinations using CombinationExpression class which uses FilterCombination Enumeration of C1.DataCollection to add AND/OR logical functions. The table below describes the available logical functions.

Function	Description
AND	The function returns TRUE if all the arguments are TRUE.
OR	The function returns TRUE if any argument is TRUE.

Filter Operation

Further, you need to add the filter operations using OperationExpression class which enables the user to select the property name to which the expression applies, value of filter expression, and type of logical operation according to the selected field type using FilterOperation Enumeration of C1.DataCollection. The table below describes the available logical operators.

Condition	Description
Equal	Returns the values equal to the entered value.
NotEqual	Returns the values not equal to the entered value.
GreaterThan	Returns the values greater than the entered value.
GreaterThanOrEqual	Returns the values greater than or equal to the entered value.
LessThan	Returns the values less than the entered value.
LessThanOrEqual	Returns the values less than or equal to the entered value.
EqualText	Returns the values equal to the entered text.
NotEqualText	Returns the values not equal to the entered text.
Contains	Returns the values containing entered value.
StartsWith	Returns the values starting with entered value.
EndsWith	Returns the values ending with entered value.
IsOneOf	Returns the value one of the entered values.

The image below shows the creation of filter expression by adding different combinations and operations.

Filter editor with filter expression by adding different combinations and operations

Below code example demonstrates the implementation of Filter Combinations and Operations in FilterEditor as shown in the above scenario.

C#
Visual Basic

private static CombinationExpression GetPredefinedFilter()
{
    var filterExpression = new CombinationExpression();
    var filterExpressions = filterExpression.Expressions;
    var NameContainsExpression = new OperationExpression()
    {
        // ANDの組み合わせに最初の操作を追加します
        PropertyName = "Name",
        FilterOperation = FilterOperation.Contains,
        Value = "a"
    };
    filterExpressions.Add(NameContainsExpression);
    var CountryNotEqualExpression = new OperationExpression()
    {
        // ANDの組み合わせに2番目の操作を追加します
        PropertyName = "Country",
        FilterOperation = FilterOperation.NotEqualText,
        Value = "Myanmar"
    };
    filterExpressions.Add(CountryNotEqualExpression);
    //新しいORの組み合わせを追加します
    var OrExpression = new CombinationExpression();
    OrExpression.FilterCombination = FilterCombination.Or;
    var brandExpressions = OrExpression.Expressions;
    //ORの組み合わせに最初の演算を追加します
    var IDGreaterThanExpression = new OperationExpression()
    {
        PropertyName = "ID",
        FilterOperation = FilterOperation.GreaterThan,
        Value = "3"
    };
    brandExpressions.Add(IDGreaterThanExpression);
    //ORの組み合わせに2番目の操作を追加します
    var NameEndsWithExpression = new OperationExpression()
    {
        PropertyName = "Name",
        FilterOperation = FilterOperation.EndsWith,
        Value = "n"
    };
    brandExpressions.Add(NameEndsWithExpression);
    filterExpressions.Add(OrExpression);
    return filterExpression;
}

Visual Basic

Private Shared Function GetPredefinedFilter() As CombinationExpression
    Dim filterExpression = New CombinationExpression()
    Dim filterExpressions = filterExpression.Expressions
    ' ANDの組み合わせに最初の操作を追加します
    Dim NameContainsExpression = New OperationExpression() With {
    .PropertyName = "Name",
    .FilterOperation = FilterOperation.Contains,
    .Value = "a"
}
    filterExpressions.Add(NameContainsExpression)
    ' ANDの組み合わせに2番目の操作を追加します
    Dim CountryNotEqualExpression = New OperationExpression() With {
    .PropertyName = "Country",
    .FilterOperation = FilterOperation.NotEqualText,
    .Value = "Myanmar"
}
    filterExpressions.Add(CountryNotEqualExpression)
    ' 新しいORの組み合わせを追加します
    Dim OrExpression = New CombinationExpression()
    OrExpression.FilterCombination = FilterCombination.[Or]
    Dim brandExpressions = OrExpression.Expressions
    ' ORの組み合わせに最初の演算を追加します
    Dim IDGreaterThanExpression = New OperationExpression() With {
    .PropertyName = "ID",
    .FilterOperation = FilterOperation.GreaterThan,
    .Value = "3"
}
    brandExpressions.Add(IDGreaterThanExpression)
    ' ORの組み合わせに2番目の操作を追加します
    Dim NameEndsWithExpression = New OperationExpression() With {
    .PropertyName = "Name",
    .FilterOperation = FilterOperation.EndsWith,
    .Value = "n"
}
    brandExpressions.Add(NameEndsWithExpression)
    filterExpressions.Add(OrExpression)
    Return filterExpression
End Function

Apply and Clear Filter

To apply the filter conditions given in example above, FilterEditor provides ApplyFilterAsync method that applies the filter to the data source asynchronously. You can also use ClearFilter method that removes all the expressions from the filter as shown in the GIF below.

To implement apply and clear filter feature, you can use the following code example.

C#
Visual Basic