Sorting, Filtering, and Search
Overview
This guide explains how to quickly find the information you need from large amounts of data in your tables.
The search box and each column's filter/sort icons are hidden by default. Click the search icon in the toolbar above the table to reveal them.
Sorting
Basic Sorting
Steps:
- Click the small filter icon inside the header of the column you want to sort by
- In the popover that opens, select "Ascending" or "Descending"
The same popover also shows the filter input field, so you can set sorting and filtering together.
Ascending/Descending examples:
Number (number):
Ascending: 1, 2, 3, 4, 5 ...
Descending: 100, 90, 80, 70 ...
Date (date):
Ascending: 2025-01-01, 2025-02-01, 2025-03-01 ...
Descending: 2025-12-31, 2025-12-30, 2025-12-29 ...
Text (string):
Ascending: A, B, C ... a, b, c ...
Descending: Z, Y, X ... z, y, x ...
Multi-column Sorting
Clicking a column's sort icon always makes that column the top sort priority, and any sorting you had set before automatically drops to a lower priority.
If you want to control the priority yourself, open the dialog from the "Sort" icon in the toolbar. From there you can:
- Add a sort condition
- Choose the column
- Switch between ascending and descending
- Reorder the priority of conditions
- Remove a condition
Example:
Primary sort: Priority (Descending: High -> Medium -> Low)
Secondary sort: Due Date (Ascending: Oldest -> Newest)
Filtering
Column Filters
Steps:
- Click the small filter icon inside the header of the column you want to filter (the same icon used to open sorting)
- Set the filter conditions in the input field inside the popover
Filter Conditions by Data Type
string / rich_text / markdown
- Contains (like): Includes the specified text
- Equals (eq): Exact match
- Not equal to (neq): Does not match
- Starts with (startsWith): Begins with the specified text
- Ends with (endsWith): Ends with the specified text
- Blank (null): No data entered
- Not blank (notNull): Data has been entered
Example:
Task Name contains "login"
-> "Implement login feature", "Login screen design", etc.
number
- Equals (eq)
- Not equal to (neq)
- Greater than (gt)
- Greater than or equal to (gte)
- Less than (lt)
- Less than or equal to (lte)
- Between (between): Within the specified range
- Blank (null): No data entered
- Not blank (notNull): Data has been entered
Example:
Progress >= 50%
-> Shows tasks at 50%, 75%, 100%
date / datetime
- Equals (eq): The specified date
- Not equal to (neq): Any date other than the specified date
- Before (lt): Earlier than the specified date
- On or before (lte): The specified date or earlier
- After (gt): Later than the specified date
- On or after (gte): The specified date or later
- Period (between): Within the specified date range
- Blank (null): No data entered
- Not blank (notNull): Data has been entered
Example:
Due Date is "This week"
-> Shows tasks due Monday through Sunday of this week
The date/datetime input also offers one-click shortcuts for common ranges like "Today," "Yesterday," and "Last week."
select (single selection)
The list of options is shown as checkboxes. Only rows whose value matches a checked option are shown.
The list also includes a "(Blank)" item. Checking it also shows rows where nothing has been selected yet.
multi_select (multiple selection)
Just like select, check the options you want to include from the list of checkboxes. Checking multiple options shows rows that match any of them.
Checking "(Blank)" in this list also shows rows where nothing has been selected yet.
Example:
Status is "Not Started" or "In Progress"
-> Shows incomplete tasks
checkbox
- All: No filter (shows every row)
- On: Shows only checked rows
- Off: Shows only unchecked rows
Example:
Done is "Off"
-> Shows incomplete tasks
Multiple Filter Conditions
You can combine conditions using AND/OR logic.
Example:
Condition 1: Status = "In Progress"
AND Condition 2: Priority = "High"
-> Shows only high-priority tasks that are in progress
Search
Full-text Search
Steps:
- Enter a keyword in the search box at the top of the table
- Press Enter
- Matching rows are displayed
Search targets:
- All string, rich_text, and markdown columns
- Options in select and multi_select columns
Example:
Search keyword: "login"
-> Shows rows containing "login" in the task name, description, notes, etc.
Saving Filters as Views
Frequently used filter conditions can be saved as Views.
For details, see [Views for Data Extraction](./Views for Data Extraction.md).
Practical Examples
Example 1: Show Incomplete Tasks
Filter conditions:
- Status = "Not Started" OR "In Progress"
Sort:
- Primary: Priority (Descending: High -> Low)
- Secondary: Due Date (Ascending: Oldest -> Newest)
Example 2: Show Tasks Due This Week
Filter conditions:
- Due Date >= This Monday
- Due Date <= This Sunday
Sort:
- Due Date (Ascending)
Example 3: High-priority Tasks with 50%+ Progress
Filter conditions:
- Priority = "High"
- Progress >= 50%
Sort:
- Progress (Descending)
Tips and Tricks
1. Save and Reuse with Views
Save frequently used filter conditions as views.
View 1: Incomplete Tasks
View 2: Due This Week
View 3: High-priority Tasks
2. Combine Multiple Conditions
Use AND/OR conditions for more specific filtering.
3. Use Search and Filters Together
When working with large datasets, combining search and filters is the most efficient approach.
FAQ
Q1: How do I clear a filter?
A: Click the filter icon on the column header, then select "Clear" or "Reset" in the popover.
Q2: How do I clear sorting?
A: Open the dialog from the "Sort" icon in the toolbar and select "Clear All" to remove every sort. To clear just one column, select "Clear Sort for This Column" from that column's header.
Q3: What is the difference between a filter and a view?
A: A filter is a temporary data restriction, while a view is a saved set of filter conditions. Save frequently used conditions as views for quick access.
Comments