Lists : Filter editor function
Filter editor function
The filter editor is used to filter the list entries in any degree of complexity. The filter editor is opened by selecting the symbol in the toolbar.
A filter consists of filter equations and their logical links.
A filter equation consists of the column designation (green text) of the column that is to be filtered, the filter condition (blue text) and the filter value (white text). The number of filter values depends on the filter condition.
The column designation, filter condition and logical link are selected in the matching fields. This opens a list of selection options for each case.
Selection lists
Show, enable/disable, edit and delete filter functions
An active filter is marked accordingly:
1. The filter function is shown in the footer of the left-hand list view.
2. All filtered columns are marked with the filter symbol .
3. A symbol to edit the filter function is shown on the right-hand side of the footer.
4. A symbol to delete the filter function is shown on the right-hand side of the footer.
Functions of the toolbar
Save changes
Cancel editing
Print, refer to “Print”
The filter list can be sent to a printer here or saved as a .pdf, .doc or .docx file. Barcodes and master data for selected objects can be printed out or saved.
Export to Excel
This function is used to export the filter list to Excel as a CSV file. Clicking on the symbol opens the Windows menu “Save as”. Users can select the preferred storage location here. Then they must add a file name. Export is completed by clicking on “Save”.
The search function is used to locate search terms in all columns. Clicking on this search symbol opens a search window in the header of the list view. After selecting the input field, the search term is added here. The search results are marked in yellow. The search term and therefore the markings are deleted by clicking on the delete symbol in the search window . The search is closed by selecting “Close”.
Column editor
Selecting this symbol opens a column editor that contains all column designations. You can use drag-and-drop to pull the columns from the container to the chosen position in the list header. This will delete the entry in the container. An orange double arrow marks the position at which the new column will be inserted. Columns can be deleted from the list (moved to the column editor) by pulling them out of the list header by drag-and-drop.
Filter editor function
See above for the description
This function is used to optimize the column width for all columns.
Video „Working with the list filter functions, sorting, filter editor and column assistant“
Video „Working with the list, creation of Excel file“