Sorting and Filtering Lists

In any module with a list, you can apply filtering and sorting to efficiently find information.

Sorting

Click on the Sort bybutton to show the menu of fields by which you can sort. Clicking a field will change the sorting, and a downwards or upwards arrow is displayed next to the field name, indicating ascending or descending sorting order. You can sort a list by multiple fields by adding them in the order you want to sort them.

In some lists, it is possible to sort by column. Those lists will have clickable column names, and a sort direction arrow will be visible next to the column name. You can sort by multiple columns by holding down the shift key while clicking on the column headers.

When sorting calculated fields, the sorting will only consider the fields that are visible in the list.

Filtering

Quick filters

Located above the lists, quick filters offer a convenient way to narrow down information.

"Voyages" module quick filters

1. To activate a filter, click on it and choose one or more values.

2. To remove a specific option from a filter, click the filter button and uncheck the value.

3. To clear all options from a filter, click the Clear button inside the filter.

Column filters

Certain list columns have a Filter button when hovering the cursor over them. Clicking the button will display a filter for the elements in the column.

Advanced Filters

Narrow any list or grid to exactly the records you need — combine field conditions with AND/OR logic and group them with parentheses. No query language required.

Getting started

1. Open a list/grid and click Advanced Filters.

2. The builder opens empty. Build it up with:

   • + Add Condition — one field rule (Field + Operator + Value).

   • { } Add Group — a parenthesised group with its own AND/OR logic.

3. A live Preview shows the expression as you build. Click Apply to run it. (Clear All resets, Cancel closes.)

Operators by field type

The field's type (shown as a tag next to the field name) decides which operators are available:

Field type	Available operators
string	=, !=, Contains, StartsWith, EndsWith, In, Null, NotNull
number (double, etc.)	=, !=, >, >=, <, <=, Between, In
boolean	=, != (value is True / False)
date	On, After, On or after, Before, On or before, Between, Is empty, Is not empty
object (a list/collection, e.g. cargos)	Empty, Not Empty

What to keep in mind

• AND narrows, OR widens. Be mindful when mixing them - use Add Group to make the intent clear, e.g. vessel = X AND (status = ACTIVE OR status = PENDING). If results look wrong, check your grouping first.

• Drag to reorder conditions and groups (Escape cancels a drag).

• Collection fields filter on presence, not value. Picking an object field (like cargos) only offers Empty / Not Empty - testing whether the array has any items (preview shows cargos[] = Empty).

Saving

Filter state (including dynamic tokens) is preserved in the view config. Reopening a saved view reapplies the same logic with dynamic values freshly resolved.