Filtering & Sorting
Learn about Filtering & Sorting in WaymakerOS.
Find the exact rows you need with column-based filters and multi-column sorting.
Quick filter
Click the Filter button above the table to open the filter bar. Select a column, choose an operator, and enter a value.
Filter operators
| Column type | Operators |
|---|---|
| Text | equals, contains, starts with, ends with, is empty, is not empty |
| Number | equals, greater than, less than, between, is empty |
| Date | equals, before, after, between, is today, this week, this month |
| Select | equals, is any of, is none of, is empty |
| Boolean | is true, is false |
Combining filters
Click Add Filter to add multiple conditions. Filters combine with AND logic — rows must match all conditions.
Example: Show rows where Status = "Active" AND Created Date is after January 1, 2026.
Sorting
Click any column header to sort by that column:
- First click — sort ascending (A→Z, 1→9, oldest→newest)
- Second click — sort descending (Z→A, 9→1, newest→oldest)
- Third click — remove sort
Multi-column sort
Hold Shift and click additional column headers to add secondary sort criteria. The sort order is shown by numbered indicators on the column headers.
Example: Sort by "Priority" descending, then by "Due Date" ascending — high priority items first, with ties broken by due date.
Searching
Use the search box above the table to search across all text columns. The search filters rows in real time as you type.
Saving filter views
If you frequently use the same filter combination:
- Set up your filters
- Click Save View
- Name the view
- Access it later from the views dropdown
Saved views are available to everyone with access to the table.
Row count
The row count at the bottom of the table updates to show how many rows match your current filters out of the total.
Next steps
- Column Types — understand what types are available
- Data Connections — connect external data sources
- Import & Export — bring data in from other tools