Show TOC

Procedure documentationUsing Complex Filters Locate this document in the navigation structure

 

You can set up the list in such a way that you can define filters in the Settings dialog box. You can define any number of filter criteria for each column.

Note Note

If you define multiple filter criteria for a column, only those data records that fulfill each of these criteria are displayed.

End of the note.

Prerequisites

  • The Filter tab page is displayed in the Settings dialog box.

  • Filtering is permitted for the required column.

Procedure

First Filter for a Column
  1. To define a filter, open the Settings dialog box (see Using the Dialog Box with Settings for the List).

  2. If you do not want capitalization to be taken into consideration when filtering, set the Ignore Uppercase and Lowercase Distinction when Filtering indicator. This setting applies to all filters you define for the list.

  3. In the Filter Column dropdown list box, select the column for which you want to define the filter and choose Add. For each column you insert in this way, a row is displayed in which you define a filter. You can insert only one row for each column.

  4. If you want to use one comparison value only, enter it in the input field next to the column header. If you want to use a range, enter the lower limit for the range in the input field next to the column header and enter the upper limit in the To input field.

  5. To specify the operator and inclusion or exclusion, choose Inactive (Inactive). The Selection Options dialog box appears.

    • If you want to define the filter as an inclusion filter, choose the Select tab page in the dialog box.

    • IIf you want to define the filter as an exclusion filter, choose the Exclude from Selection tab page.

  6. Select the operator that you want to use for your filter. The Selection Options dialog box closes automatically. An icon with the selected operator is displayed next to the comparison value.

  7. To change the operator, choose the operator icon and repeat steps 5 and 6.

All Other Filters for a Column
  1. To define additional filters for a column, open the Settings dialog box and choose the Filter tab page. A row is displayed for every column that has a filter.

  2. To define another filter for one of these columns, choose the icon on the right-hand side of the relevant row:

    • In rows in which either no filter or only one filter has been defined, choose Extended Options (Extended Options).

    • In rows in which two or more filters have been defined, choose Extended Options (Extended Options).

    The Multiple Selection dialog box appears. If filters have already been defined, they are listed in the dialog box.

  3. Proceed as described above to define the filters. Specify all filters that you want to define for the current column in this way. Choose OK.

  4. Apply these settings to the list.

Deleting Individual Filters of a Column
  1. To delete an individual filter for a column for which you have defined multiple filters, open the Settings dialog box.

    The Filters tab page only exists if it is expressly activated for your application.

  2. Choose the Filters tab.

  3. In the row with the column whose filter you want to delete, select the icon to the right of the relevant row.

    The Multiple Selection dialog box appears. All filters of the column are listed in the dialog box.

  4. Select the entry with the filter that you want to delete and choose Delete Row (Delete Row) in the toolbar. In this way you can delete all filters as required. Choose OK.

Deleting All Filters of a Column
  1. To delete all filters at the same time for a column for which you have defined multiple filters, open the Settings dialog box and select the Filters tab page.

  2. In the row with the column whose filter you want to delete, select the icon to the right of the relevant row.

    The Multiple Selection dialog box appears. All filters of the column are listed in the dialog box.

  3. Select Delete Entire Selection (Delete Entire Selection) on the toolbar and choose OK.

Deleting All Filters of a List at the Same Time
  1. To delete all filters of a list at the same time in the Settings dialog box, open it and choose the Filters tab page.

  2. Choose Reset All.

  3. Apply these settings to the list.