đ Filtering and Sorting in Lists
In this article, you will learn how to sort and filter entries in existing lists in ValueStreamer in a targeted way. Sorting and filtering are now controlled directly in the table â sorting via the column header, filtering via a dedicated filter view. This helps you find relevant entries faster and keep an overview.
đ Contents
- Quick sorting via the column header
- Pinning, hiding, and managing columns
- Quick filtering via the filter view
- Saving a view
- Default sorting in the list template
- Tips & Best Practices
- FAQ
đŧ Quick sorting via the column header
Sorting is no longer done via a central icon at the top right, but directly at the respective column.
- Open the desired list.
- Move the mouse pointer over the column header you want to sort by (e.g. "Storage location") and click the three-dot menu (âŽ) of the column.
- Select "Sort ascending" or "Sort descending".
- An arrow (â / â) next to the column name indicates the active sort direction.
đ¸ Screenshot: Column menu "Storage location" with sorting options
âšī¸ Note: Using "Deactivate sorting" in the same menu removes the column's sorting again.
⨠Tip: You can also toggle the sorting directly by clicking on the column title (ascending/descending).
đ Pinning, hiding, and managing columns
The same column menu (âŽ) offers further options for adjusting the table view:
- Pin left / Pin right â fixes the column at the edge during horizontal scrolling.
- Hide â hides the column from the current view.
- Manage columns â opens the selection of which columns are displayed.
đ¸ Screenshot: Column menu with "Pin", "Hide", and "Manage columns"
âšī¸ Note: These settings affect your current view, not the underlying list template.
đ Quick filtering via the filter view
The filter is still opened via the filter icon, but now uses a structured builder view consisting of column, operator, and value.
- Open the desired list.
- Click the filter icon (funnel) at the top right.
- Define the filter condition:
- Column â select the column to be filtered (e.g. "Done").
- Operator â choose the condition (e.g. "is").
- Value â choose the comparison value (e.g. "No").
⨠Tip: Use "Add filter" to combine multiple conditions. Remove a single filter via the à to its left, or all filters via "Remove all".
âšī¸ Note: You can also open the filter directly from the column menu (âŽ) via "Filter" for the respective column.
đž Saving a view
Sorting, filters, and column arrangement initially apply to your current session. Using the "Save view" button at the top right, you can permanently save the current display.
â ī¸ Caution: Without saving, the default sorting configured in the list template is applied again when the page is reloaded.
âšī¸ Note: Which saved views are visible to other users depends on your permissions and the team/template configuration.
âī¸ Default sorting in the list template
The permanent default sorting that applies to everyone is not defined in the list itself, but in the list template, and is reserved for administrators.
âšī¸ Note: You can find the configuration of the default sorting logic in the article đ Creating and managing list templates.
⨠Tips & Best Practices
- â Use the filter to display relevant entries in a targeted way during meetings or reviews (e.g. "Done is No").
- â Sort by important fields such as "Date" or "Priority" to keep an overview.
- â Save recurring views via "Save view" instead of setting sorting and filters anew each time.
- â Hide rarely used columns via "Hide" to keep the table clear.
â FAQ
How do I sort a list? Click on the column header or the three-dot menu (âŽ) of the column and select "Sort ascending" or "Sort descending". The arrow next to the column name shows the active direction.
Where do I find the filter? Via the filter icon (funnel) at the top right, or directly via "Filter" in the column menu (âŽ). The filter is built as a condition of column, operator, and value.
Can I use multiple filters at the same time? Yes. Use "Add filter" to combine any number of conditions. Use "Remove all" to reset all filters.
Are sorting and filters retained after reloading? Only if you save the view via "Save view". Otherwise, the default sorting from the list template applies again after reloading.
How do I define a permanent default sorting for everyone? This is not done in the list, but in the list template by an administrator (see the article "Creating and managing list templates").