Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Filtering, sorting and exporting a table

&pagelevel(4)&pagelevel

On the tabs, the properties of the objects are listed in one or more tables. When a tab is called for the first time, all the data available for the function selected is displayed in a default sort (sorting column and sorting direction). The table column according to which the table is sorted is highlighted.

In some cases, the default sorting is neither ascending nor descending but by some other criterium. For example, the units in the unit table may be listed in the same order as in the navigation.

You can change the sorting criteria for the tables (columns) and, by filtering, the volume of displayed data.

The following properties are persistent, i.e. they are retained even when the window is changed and in the case of automatic update.

  • Filter and sort

  • Scroll position

  • Page if scrolling pages is possible

  • Status (expanded or collapsed) if expandable elements are contained

As soon as a table is being sorted or filtered, the Reset table to default view icon () appears beneath it. Click the icon to obtain the table in the default sort and without filters. To obtain all tables in the default sort and without filters, click on Login information and select Reset tables.

For automatic updates see section "Automatic update".

As soon as a table contains more objects than are set in Per page, a control bar appears above the table containing the functions for scrolling and for paginating the objects to be displayed. Details for controlling the table view are provided in the SE Manager help.

Filtering a table

Filters reduce the number of data displayed in a table based on certain criteria and make handling large tables easier. You can use free text filters and filter lists to filter the data used to build up a table.
The filters for different table columns can be combined.

If a filter is set, the filter's field is highlighted.

With a free-text filter, hits are searched for at every position of a cell without differentiating between upper and lower case. Otherwise, the rules for the so-called regular expressions apply when searching.

Detailed information on filtering tables is provided in the SE Manager help. Here, the different filter options are described at the places where they can be used.

Sorting a table

A table is sorted according to the values of a selected column.

>

Drag the mouse cursor over the column headings in the table.
When the mouse cursor turns into a symbolic hand, you can sort the table according to the values of this column.

>

Click the column heading.
The table is newly sorted. The selected column is highlighted.

If you click on the same column heading again, the sort order changes from ascending to descending or vice versa.

Sorting according to a different column cancels the previous sort order.

Export of table data

You can either print the data of a table or export it in XLSX format. To do this, choose the icon  below the table to call up the Export of table dialog. Details can be found in the online help.