Skip to main content
Skip table of contents

Sort and filter search results in a list

Tables can be sorted by a column by clicking on the column header. Columns are initially be sorted in descending order. Clicking again on the same column will switch between descending and ascending order.

The filter field can be found directly under the column name. The width of the filter field is based on the width of the column. The column filter is also available in the tile view of the activity list with a fixed column width.



After entering the filter criterion, you do not have to perform any actions. After a few seconds, the filter is applied. The filter type used per default is 'starts with'. By using the characters '?', '*' or '|' the filter type changes to regular expressions.

Numbers and date fields are filtered and sorted by their text representation. Boolean values (true, false) can be filtered using 'true' and 'false'. Lookup fields are treated according to their layout (key, description).


Examples

FunctionSpelling
Contains 'ABC'*ABC*
Ends with 'st'*st
If 'APPOINTMENT' or 'TASK'TASK
Words such as 'start' or 'smart's?art
Is an activity copy*[Copy]
does not contain
  • !query searches for all rows that DO NOT contain the query.
  • !! query searches for all rows that contain !query (Escape mechanism with duplication).
  • ! searches for all rows in which the field value is empty


In addition to the page number, the number of entries in the table is visible. If this is filtered, you can see the number of filtered entries.,


After filtering a column, the page navigator always jumps to the first page.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.