Lists in Windows Client

Limit list content by column filter

Every column of a list has an entry field above the column header (column filter). By entering a filter criteria, the list is reduced to datasets that match that criteria.

Example: When entering filter criteria 'CUR', only data that start exactly with 'CUR' are displayed.

Additionally, you can use wildcards:

*	Represents arbitrary many symbols or no symbol.
?	Represents one symbol.

Examples for filtering CURSOR GIESSEN:

CUR*	Finds all entries beginning with 'CUR'. In this case, you can also forego the wildcard. The entry 'CUR' is interpreted as 'CUR'. This only applies if only the wildcard was set, and only to the end of the entry.
CURGI	Finds all entries that lie between 'CUR' and 'GI' and have arbitrary many characters behind 'GI'. If you would spare the * behind 'GI', 'CURSOR GIESSEN' would never be found, only 'CURSOR GI'.
CUR?OR*	Finds all entries, which have exactly one symbol between 'CUR' and 'OR' and arbitrary many characters behind 'OR'.
*GIESSEN	Finds all entries which have arbitrary many characters in front of 'GIESSEN'.
(?!MAILIN)*	Does not start with 'Mailin' (filter with 'unequal') To try to solve this problem with [^MAILIN]* does not work as this means: Does not start with 'M' Does not start with 'A' Does not start with 'I' etc.

If you enter filter criteria for several columns, only those data are displayed that fulfill all criteria.

List View Configuration

For a better overview, the display of a list can be changed.

The data are sorted starting in a list from the left column in decreasing order. You can change the order of individual columns and their visibility. You do this either directly via 'Drag and Drop' or via the dialogs in the menu

List View Configuration.

Change column order and their visibility

Click on a column header and the list is sorted in ascending order depending on that column. Every click switches between increasing and decreasing order. If you want to set the order using several columns, hold down the SHIFT ⇧ key and click on the columns in the desired sorting order one after the other.

To change the position of a column, left click it in the area of the column header or the filter field. Move the column while holding the mouse button until it reaches its destination.

The width of a column can be changed by placing the mouse on the right column edge in the area of the column header resp. the filter field. When the mouse arrow becomes double headed, hold down the left mouse button. If you now move the mouse, the column edge is changed accordingly.

Alternatively, open the menu

List View Configuration → Configure visibility and order of columns. In the dialog you activate or deactivate the columns, with a click on the arrows you change the order of the columns.

Editing mode

In list view, changes to the dataset are only done in editing mode. These are automatically saved without prompt after they have been entered.

Principally, data in list view are displayed in read-mode. When you set the focus on a field, the field and the line are marked. Another mouse click or F2 switches to editing mode.

In editing mode, a field gets an additional inner frame and shows special features of the field type (e.g. magnifying glass for lookup file).

1. With copy and paste (CTRL+C and CTRL+V) you can copy data into the clipboard and paste them to other applications. When you mark the contents of a field in editing mode, only these contents are copied to the clipboard. If the field is only marked and not in editing mode, the contents of the entire line (the dataset) are copied to the clipboard (see Marking lines).

2. Optionally, you can set optionally that editing mode is automatically started when switching to a field in list view. For that select Edit focused cell under Options/ User preferences/ Lists.

Marking lines

To mark a single line, left click on it. Instead of the mouse you can also use the keyboard. Move the line mark to the desired line using ↓ or ↑.

To select multiple lines, click and hold down the CTRL key or press the CTRL+SHIFT ⇧ key combination. With the CTRL key, only the clicked line is added to the already marked ones. When the SHIFT key SHIFT ⇧ is pressed, all datasets from the last selection up to and including the line clicked on are selected. Alternatively, you can click on the first line and drag it to the last line.

With the keyboard, you can only select an area. Press and hold the SHIFT ⇧ button to move the line marker with ↓ or ↑.

1. With CTRL+↑ you move the focus from a field in the list (field marked blue) to the column filter.
2. The data of a marked line can be copied to other applications (e.g. to MS Excel) through copy and paste (CTRL+C and CTRL+V).

Saving adjustments

You have the option of saving your changes to the results list of a search (column width, column and sorting order) as default. After applying your changes, click Save user preferences in the menu Table Config / Configuration settings. These settings are valid until the next change of settings.

Changes to the results list can be restored to default by selecting Table Config / Configuration settings / Load user preferences.

Deleting several datasets

In case several datasets are marked and deleted in list view, it is additionally checked whether they have enough rights. A dialog indicates that only datasets you are having the rights for are deleted. The dialog informs you about the datasets you will be deleting.

After the deletion process all datasets which could not be deleted upon missing rights are listed in the dialog.