Table of Contents

Sorting, Browsing, and Filtering

There are several ways to narrow down records in a list or report, such as: sorting, searching, and filtering. You can also use the different methods in combination.

Sorting

To sort a list, click the column header. The arrow next to the column header indicates the sort order. By clicking several times, you can switch the sort order between ascending or descending.

Note

Not all columns support sorting. e.g.: images, icons, blob fields or columns that are based on complex calculations.

Above each list page is the Quick Search Quick Search., which provides an easy way to collapse the records of a list. This type of filtering is performed using the Starts with operator. Click the arrow to the right of the quick search to choose which fields to search. The currently selected field is visible in the background as long as no input has been made.

Tip

By right-clicking on a column header in the list, the quick search can be set to this field.

For shipments specifically, you can also define a search code. The advantage of the search code is that you can search for multiple shipment properties at the same time. The search code is set in the TrackingSearchFields field in the system configuration under the Public Tracking Configuration menu. From here, select the fields by which you want shipments to be found. The TrackingSearchMaxAge parameter specifies the maximum number of days back the sending age. Older shows are no longer in the search index.

Setting Filters in Lists

The Filter function provides the ability to collapse the records in a list and show only the records that contain the data you are interested in.

The available filter criteria differ according to the type of object (shipment, order, transport, etc.)

Note

administrators can limit the available filters by defining views.

In the filter dialog, select the fields you want to apply.

Filter

Additional filter criteria can be added with the plus button. The filter criteria are and linked (so they all have to apply at the same time), unless the same field is added multiple times with the operator Equal or Starts with, then these fields will be or linked.

Example: filter criteria And-Linked

  • Sender country equals AT and
  • Sender postal code equal to 1010

Result: Returns shipments whose sender is in Austria and the postal code 2351.

Example: filter criteria Or-Linked

  • Shipper Reference 1 Starts with PO# oder
  • Shipper Reference 1 Starts with REF#

Result: Returns shipments whose Shipper Reference 1 starts with PO# or REF#.

The Restore Default Filter option resets all filter criteria to the default state. This can be preset by the administrator.

Filter Criteria and Operators

Depending on the data type of the field, different operators are available.

Operator Displayed Records
Equals 1010 All records where the field is equal to 1010.
Unequal 1010 All records where the field is not equal to 1010.
Bigger 100 All records where the value of the field is greater than 100.
Greater than or equal to 100 All records where the value of the field is equal to or greater than 100.
Smaller 100 All records where the value of the field is less than 100.
Less than or equal to 100 All records where the value of the field is less than or equal to 100.
Starts with John Doe All records where the value of the field starts with John Doe. Upper and lower case is irrelevant.
Doesn't start with John Doe All records where the value of the field does not start with John Doe. Upper and lower case is irrelevant.
Contains John Doe All records where the value of the field is {John Doe**. Upper and lower case is irrelevant.
Ist 10.10.2023 All records where the field corresponds to the date 10/10/2023.
Is not 10.10.2023 All records where the field not corresponds to the date 10.10.2023.
From 10.10.2023 All records with the date on or after 10.10.2023.
To 10.10.2023 All records with the date before 10.10.2023.

Update

The Update function provides the ability to reload the records in a list.

See also