Understanding the logic of the AND and OR operators in filters

When working with data grids, process grids and ad hoc reports in v10, a specific filtering logic is applied when applying several values for a single criterion in a column ("OR" logic) and when applying several filters on a single column ("AND" logic).

This article focuses on the explanation of both methods when filtering grids or ad hoc reports in the beqom Web Application.

"OR" filtering logic

When filtering data grids, process grids or ad hoc reports, users have the possibility to apply a filter with multiple values on a same column using the "in" or "not in" operators. When using this method, the application applies the "OR" logic to the entered values, meaning that the returned results will include/exclude either of the defined values.

This is an attention message.

It is only possible to define several filter values for string-type criteria.

As illustrated in the following movie, this filtering process is done by entering multiple values separated with a comma. Here we want to filter the grid to display the information linked to the employees named "Abril" and "Barbara".

"or" filtering logic

In the above example, the mathematical formula for this query would be:

"AND" Filtering Logic

When working in data grids, process grids and ad hoc reports, users can apply several filters on a same column. In that case, the application applies the "AND" logic to the filters, meaning that the returned results will match ALL the defined criteria. As a result, the more filters you define, the fewer records you will see in the grid or report.

To better understand this logic, we consider as an example the following filtering process in a data grid: only display payees with a median value range from 40'000 to 35'000.

"and" filtering logic

Complex Filtering Scenario

We want to create a complex filtering scenario to better visualize the logic. In the following scenario, I would like