Use an advanced filter

Using the advanced filter, you can filter one field by multiple values (you can use both an AND and an OR filter). Because of the way this window is laid out, you have easy access to the filter criteria.

If you filter by a column that has empty cells, these cells are filtered out. If you do want to see the empty cells when using a filter, you can achieve this by also filtering the field on =[].

Display the Filter window

You will display the Filter window and define an advanced filter.

Display the Advanced filter window:

1. Go to: Financial / Debtor / Debtor.
2. Open the view: Alle debiteuren.
3. Display the filter window using one of the following options:
   • Click on the filter symbol and click on Show filter:

     

   • Right-click in the view. Click on:Run filter / Show filter.

     

   • Use the Ctrl+F hotkey.
4. Select Advanced filter.

   Below you see an example of an advanced filter. In the Field name column, select the field by which you want to filter. You can filter by all fields that are in the view or by a combination of those fields.

   

5. Click on: OK.

The check boxes at the bottom of the filter work in the same way as the ones in the simple filter.

AND filter on one field

You want to apply multiple filter criteria to the same field and the field must meet all criteria (AND filter).

Use an AND filter on one field:

1. Open the view:.
2. Open the Advanced filter.
3. Select the Field name and specify the filter value. Repeat this on the next line using the same Field name and the following filter value:

   

4. Click on: OK.

   This search returns two hits: Jansen Adviesbureau VOF and Moens en Jansen Advies VOF.

Filter by two or more criteria using OR

You want to apply multiple filter values to the same field and the field must meet at least one filter criterion (OR filter).

Use an OR filter on one field:

1. Open the view:.
2. Open the Advanced filter.
3. Select the Field name, but enter the values in different columns.

   

4. Click on: OK.