Filtering Lists

VOSS-4-UC Legacy Admin Portal allows you to filter lists in order to view only data based on specific criteria. This includes Transactions and their Sub Transaction and Log lists. For transactions, refer to Filtering Transactions.

A Filter button is available next to the Items/Page drop-down at the bottom of a list. A filter icon (with the same functionality) is also available next to each column on which you can filter. This is only visible when you mouse hover on the column headings. The Filter button on each page defaults to the first column on the page, whereas the filter icon next to the column defaults to that specific column. Click the button (or icon) to open the multi filter dialog.

A filter instance consists of a selected column, a filter operator and a value. Available filter operators are:

  • Contains
  • Does Not Contain
  • Starts With
  • Ends With
  • Equals
  • Not Equal

Note

  • The Contains filter operator and the Ignore Case check box = Selected, are applied by default. Add more filter fields as required.
  • The sorting of columns (ascending or descending) by clicking column headers while a filter is applied, is only supported for the Starts With operator.
  • To filter for rows with no value in a selected Column, choose any Filter Type option, select the Ignore Case check box and type None in the Value. This works for all list views except Subscriber
  • The Located At column will only filter on the actual hierarchy name and not the displayed text next to it, for example “site”, “customer”, and so on.

Filter instance rows can be added or removed on the dialog to create a filter. The combination of instances create a single filter where all instance rows are applied, in other words, in a logical AND.

String values are case sensitive, unless the Ignore Case check box is selected. All the filter operators apply to strings.

For Boolean values in a column, the filter is applied using any filter operators, but only with values “True”, “true”, “False” or “false”.

Number values in a column also use Equals and Not Equal filter operators. For floating point values, at least one decimal digit is required for filtering, for example 2.0. Filtering can be applied to values with decimal values up to 7 decimals. For example, consider a list of values:

2.2000001
2.0000001
2.00000001

The filter: Not Equal to 2.00000001 displays only one value (2.2000001), because the filter value has more than 7 decimals.

To apply the filter, press Enter or click the Apply button. This will hide the active filter dialog and show the filtered list. An X button shows next to the active Filter button.

For model lists, actions can then for example be carried out on a selection of items from the filtered list. The filter remains active until it is removed or until the user session on the Legacy Admin Portal ends.

For all types of filters, the Filter button funnel icon is black when a filter is active, and white when no filter is present.

A funnel icon also shows in the list header to indicate that a filter is active and that the list is currently filtered. An X button shows next to the active Filter button.

If a filter is active on a list, click the Filter button to display the multi filter dialog again.

Close an unapplied filter dialog by clicking outside it. Unapplied filters are lost when the dialog is closed.

A filter remains active even when navigating away from the list. More than one filter can therefore be active on lists available in a session on the Legacy Admin Portal.

Remove an active filter by clicking the Remove button on the multi filter dialog or by clicking the X button next to the active Filter button.

Important

Standard list view filters on model types will be removed and replaced by any Configurable Filters on landing page links or menu items for the corresponding model type when these are used. See: Configurable Filters in Menus and Landing Pages.

A filter example is shown in the figure below.

filter