Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After setting prior filters and conditions, you can then specify and enhance your filter by grouping and through the use of AND and OR. In this section, you can visually see the rule being built as you specify the base conditions. As each condition in Other Filter Items is created, it is added with the AND function.

To create a more advanced filter, you may edit this rule and modify to include parentheses for grouping and modify, add, or remove any AND or OR functions. You can specify how each of the previous filters and conditions relate to each other based on their identifier. Each condition in  in the Other Filter Items section is identified by the number in the No. column, the Date Range as "A," and the Submission State as "B."

To edit the Logic Expression, select the Edit button to the right of the field where the expression is being built.
Image Added

For example, to retrieve submissions where testPhone1 contains "11" or "123," and "Option 2" was selected from the testDropdown1 control, the Logic Expression was edited as follows to group and change a couple AND functions to OR functions: 
Image Added

This displays the following records:
Image Added

Submissions Table

...