By default, the FilterCriteria property is empty. Use the FilterCriteria property to specify whether you need to filter items using OR, NOT operators between columns. If the FilterCriteria property is empty, or not valid, the filter uses the AND operator between columns. Use the FilterCriteria property to specify how the items are filtered. Use the DisplayFilterList property to specify whether the column's header displays a drop down filter button. You can use the FilterBarPromptVisible property to show or hide the control's filter prompt field.

The FilterCriteria property supports the following operators:

• not operator ( unary operator )
• and operator ( binary operator )
• or operator ( binary operator )

Use the ( and ) parenthesis to define the order execution in the clause, if case. The operators are grided in their priority order. The % character precedes the index of the column ( zero based ), and indicates the column. For instance, %0 or %1 means that OR operator is used when both columns are used, and that means that you can filter for values that are in a column or for values that are in the second columns. If a column is not grided in the FilterCriteria property, and the user filters values by that column, the AND operator is used by default. For instance, let's say that we have three columns, and FilterCriteria property is "%0 or %1". If the user filter for all columns, the filter clause is equivalent with ( %0 or %1 ) and %2, and it means all that match the third column, and is in the first or the second column.