Sorting, Filtering, and Search

Overview

This guide explains how to quickly find the information you need from large amounts of data in your tables.

---

Sorting

Basic Sorting

Steps:

1. Click the header of the column you want to sort by
2. Select "Ascending" or "Descending"

Ascending/Descending examples:

Multi-column Sorting

1. Set the first sort column
2. Hold the Shift key and click the next sort column

Example:

---

Filtering

Column Filters

Steps:

1. Click the header of the column you want to filter
2. Select "Filter"
3. Set the filter conditions

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
• Is empty (null): No data entered
• Is not empty (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
• Is empty (null): No data entered
• Is not empty (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
• Between (between): Within the specified date range
• Is empty (null): No data entered
• Is not empty (notNull): Data has been entered

Example:

select (single selection)

• Matches any of (in): Matches any of the specified options
• Matches none of (notIn): Does not match any of the specified options
• Is empty (null): No data entered
• Is not empty (notNull): Data has been entered

multi_select (multiple selection)

• Contains (contains): Includes the specified option
• Does not contain (notContains): Excludes the specified option
• Is empty (null): No data entered
• Is not empty (notNull): Data has been entered

Example:

checkbox

• Equals (eq): Specify checked (true) or unchecked (false)
• Is empty (null): No data entered
• Is not empty (notNull): Data has been entered

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.

---

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 and select "Clear Filter."

Q2: How do I clear sorting?

A: Click the "Clear Sort" button at the top of the table.

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.