Data Grid Filter

Data Grid Filter is an advance filter component allows you to filter your data based on [IF,AND] statements and math conditions. You can filter comparing two fields or by fields value. 

Select Field - Select the field you want to filter by

Operator - Select your wanted operator [Contains, < , >, = , != …]

Value - Type in desired value, if second Option is selected, than value is not needed.

Select 2nd Field - Select this option if you want to compare between two fields. If you change it to a field, than you don't need to input any value for the filter because it will compare values from two selected fields.

"+" Button - Click button + on lower right to add one more AND statement. You can only add AND statements.

Filter Button - Click button Filter to filter out the data.

Note:

When you apply the filter, in the Button bar, next to the Filter button there will be new Remove filter button. It will clear the filter.