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:

1. Click the small filter icon inside the header of the column you want to sort by
2. 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:

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:

---

Filtering

Column Filters

Steps:

1. Click the small filter icon inside the header of the column you want to filter (the same icon used to open sorting)
2. 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:

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:

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:

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:

checkbox

• All: No filter (shows every row)
• On: Shows only checked rows
• Off: Shows only unchecked rows

Example:

Multiple Filter Conditions

You can combine conditions using AND/OR logic.

Example:

---

Search

Full-text Search

Steps:

1. Enter a keyword in the search box at the top of the table
2. Press Enter
3. Matching rows are displayed

Search targets:

• All string, rich_text, and markdown columns
• Options in select and multi_select columns

Example:

---

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

Example 2: Show Tasks Due This Week

Example 3: High-priority Tasks with 50%+ Progress

---

Tips and Tricks

1. Save and Reuse with Views

Save frequently used filter conditions as views.

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.