Filters & sorts
Narrow which rows you see, then order them. Filter and Sort live in the table
toolbar, left of Fields. The status bar shows how many rows remain after a filter
(visible/total).
Filter Company contains Acme, then sort Company Z → A. Status bar shows the filtered row count.
Overview
Filters hide rows that do not match your conditions. Sorts reorder the rows that are still visible. Both apply to the active view. They do not copy or delete data.
Agents can apply the same kind of lens through MCP. You do not need to learn a separate query language for everyday table work.
Set up
- Open a table.
- In the toolbar, click Filter or Sort (left cluster: Search → view → Filter → Sort → Fields).
- Watch the status bar: filtered tables show something like
3/5rows.
Use filters
Add a condition
- Open Filter.
- Pick a field (Where).
- Pick an operator (for example contains, is empty, equals).
- Enter a value when the operator needs one.
- Click Apply.
Add another condition when you need it. Clear removes the active filter.
What you can filter on
Common operators depend on the field type:
| Kind of field | Examples of operators |
|---|---|
| Text | contains, equals, is empty |
| Number | equals, greater than, less than |
| Checkbox | is true / is false |
| Lists | is any of |
You can combine several conditions. Today that is one flat group (all must match, or any may match), not nested groups.
Use sorts
- Open Sort.
- Choose a field and direction (A → Z or Z → A).
- Add up to two more keys if you need a tie-breaker.
- Apply.
Formula fields cannot be sorted. Pick a stored field instead.
Tips
- Save a view when you want the same filter and sort again tomorrow.
- Row counts belong in the status bar, not the toolbar.
- Clearing filter or sort is local to the view. It does not rewrite your rows.