Behaviors of filters in views

You can combine different search conditions when defining a view.

When using multiple conditions and predicates in a view, pay attention to the following:

• The predicates Or, And, and Not are now available for use.
• The Not predicate does not work if there are multiple conditions.
• When multiple conditions are defined, the or or and predicate on the last condition is not used to combine conditions.
• The predicates are applied to the conditions according to their sequential order. For example, if four conditions C1, C2, C3, C4 are defined in the following order:

      C1    and
      C2    or
      C3    and
      C4    none

  The predicates are applied to the conditions in this way (((C1 and C2) or C3) and C4).

• The value of the String type can be entered with or without double quotes when defining a condition.

Below is an example of using multiple conditions and predicates in a view. Three conditions C1, C2 and C3 are defined in a view as shown in the table, and they are combined to be ((C1 and C2) or C3), which means only the product family records whose ID is between 2 and 5 or equal 9 will be returned.