# Data source and filters

> Learn how to filter data in Tadabase to show exactly the records you need. This guide covers the fundamentals of data source filtering to get you started…

Source: https://tadabase.com/docs/learn/data-source-filters-2  
Status: Not yet re-checked. Moved from our previous help site and not yet re-checked against the current product. Last edited Jan 14, 2026.

## Data Source Filters - Introduction

[Data Source & Filters](https://player.vimeo.com/video/734812609?title=0&byline=0)

Learn how to filter data in Tadabase to show exactly the records you need. This guide covers the fundamentals of data source filtering to get you started quickly.

> **Note:** ? Looking for Complete Filter Reference? For a comprehensive breakdown of every filter operator, visual calendar examples, and advanced filtering techniques, see our detailed Manual article: **[? Complete Data Source Filtering Guide](https://tadabase.com/docs/pages/data-source-filtering)** Includes 99 filter operators, visual calendar tables, connection field filters, nested logic, and real-world examples.

## Understanding Filter Basics

### What is a Data Source?

When you add a data component (Table, List, Details, etc.) to a page, you first choose a **data source**—the table from which your component will display records. Filters then refine which of those records are shown.

> **Warning:** Key Concept Think of your data source as a warehouse of records. Filters are your search criteria that determine which records from that warehouse are displayed to users.

### Anatomy of a Filter

Every filter consists of three parts:

| Component | Description | Example |
| --- | --- | --- |
| **Field** | The field you want to filter by | "Company Name", "Status", "Created Date" |
| **Operator** | How to compare the field value | "is", "contains", "is today", "is checked" |
| **Value** | What to compare against (if needed) | "Tesla", "100", specific date |

**Example Filter:** Show records where **Status** (field) **is** (operator) **Active** (value)

## Common Filter Types

### Text Field Filters

Filter text fields like names, descriptions, and addresses.

**Common Operators:**

- **is** - Exact match
- **contains** - Includes the text anywhere
- **starts with** - Begins with the text
- **ends with** - Ends with the text
- **is blank** - Field is empty

**Example:** Filter companies where Company Name **contains** "Tech" shows: TechCorp, FinTech Solutions, BioTech Labs

### Number Field Filters

Filter numeric fields like prices, quantities, and scores.

**Common Operators:**

- **is equal to** - Exact number match
- **is higher than** - Greater than specified value
- **is lower than** - Less than specified value
- **is blank** - Field is empty

**Example:** Filter orders where Total Amount **is higher than** 1000 shows all orders over $1,000

### Date Field Filters

Filter dates relative to today or specific date ranges.

**Popular Operators:**

- **is today** - Records from today only
- **is this week** - Current Sunday-Saturday week
- **is this month** - Current calendar month
- **is before today** - All past records
- **is after today** - All future records
- **is during the previous 7 days** - Rolling 7-day window from today

**Example:** Filter events where Event Date **is this week** shows only events happening Sunday-Saturday of the current week

> **Note:** Date Filters Are Dynamic Date filters like "is today" or "is this month" automatically update as time passes. A filter showing "this week" will always show the current week, no matter when users view the page.

### Checkbox Filters

Filter yes/no fields like "Active", "Completed", or "Featured".

**Operators:**

- **is checked** - Box is checked (true)
- **is unchecked** - Box is not checked (false)
- **only show checked** - Same as "is checked"

**Example:** Filter tasks where Completed **is unchecked** shows all incomplete tasks

### Connection Field Filters

Filter records based on relationships to other tables.

**Powerful Operators:**

- **is logged in user** - Shows each user only their own records
- **is connected to current record** - Filter based on detail page context
- **is any of** - Connected to any selected records

**Example:** Filter projects where Assigned To **is logged in user** creates a personalized view where each user sees only their assigned projects

## Filter Logic: AND vs OR

When you add multiple filters, you can choose how they work together:

### Match All (AND)

Records must meet **ALL** filter conditions to be shown. This narrows your results.

**Example:**

- Status **is** Active
- **AND** Company Name **contains** "Tech"
- **Result:** Only active companies with "Tech" in the name

### Match Any (OR)

Records must meet **AT LEAST ONE** filter condition. This expands your results.

**Example:**

- Status **is** Active
- **OR** Priority **is** High
- **Result:** All active records PLUS all high priority records (even if inactive)

> **Note:** Quick Tip **Match All (AND)** = More restrictive, fewer results **Match Any (OR)** = Less restrictive, more results

## Common Filtering Scenarios

### Show Only My Records

Create a personalized view where each user sees only their own data.

**Filter:** Assigned User (connection field) **is logged in user**

### Show Recent Records

Display records created in the last 30 days.

**Filter:** Created Date **is during the previous 30 days**

### Show Active Items Only

Hide archived or inactive records from view.

**Filter:** Status **is** Active

### Show High-Value Deals

Display deals above a certain amount that are still open.

**Filters (Match All):**

- Deal Amount **is higher than** 10000
- Status **is not** Closed

## Getting Started with Filters

1. **Open Component Settings:** Click the component you want to filter
2. **Navigate to Data Source:** Find the Data Source or Filters section
3. **Add Filter:** Click "Add Filter" button
4. **Configure Filter:**
5. — Select the field to filter by
6. — Choose an operator
7. — Enter a value (if required)
8. **Set Logic:** Choose "Match All" or "Match Any" if using multiple filters
9. **Save:** Save your component settings

> **Warning:** Test Your Filters After adding filters, view your page to verify the correct records are displayed. If results are unexpected, check:

- Field names are correct
- Operators match your intent (is vs contains, AND vs OR)
- Values are formatted correctly (especially for dates and numbers)

## Advanced Topics

For more complex filtering needs, explore these advanced features in the comprehensive Manual guide:

- **Nested Filter Groups:** Create complex logic like (A AND B) OR (C AND D)
- **Date Filter Calendar Examples:** Visual representations showing exactly which dates match each operator
- **Connection Field Advanced Filters:** Role-based filtering, multi-level connections, search within connections
- **Special Filters:** Dynamic user filters, current record context, custom date ranges
- **Performance Best Practices:** Optimize filters for large datasets
- **Troubleshooting:** Solve common filtering issues

> **Note:** ? Complete Filter Reference See the **[Complete Data Source Filtering Guide](https://tadabase.com/docs/pages/data-source-filtering)** for comprehensive documentation on all 99 filter operators, visual examples, and advanced techniques.

## Quick Reference: Operators by Field Type

| Field Type | Common Operators | Use Case |
| --- | --- | --- |
| **Text** | is, contains, starts with, is blank | Names, descriptions, addresses |
| **Number** | is equal to, higher than, lower than | Prices, quantities, scores |
| **Date** | is today, is this week, is before/after | Events, deadlines, timestamps |
| **Checkbox** | is checked, is unchecked | Yes/no fields, toggles |
| **Select** | is, is any of, contains | Status, category, tags |
| **Connection** | is logged in user, is connected to | User assignments, relationships |

## Next Steps

Now that you understand the basics of data source filtering:

1. **Practice:** Add simple filters to your components and test the results
2. **Explore:** Try different operators to see how they affect your data
3. **Learn More:** Visit the [Complete Data Source Filtering Guide](https://tadabase.com/docs/pages/data-source-filtering) for advanced techniques
4. **Watch:** Review the video at the top of this page for visual demonstrations

> **Note:** Need Help? If you have questions about filtering specific to your use case, reach out to our support team or consult the [detailed Manual article](https://tadabase.com/docs/pages/data-source-filtering) for comprehensive examples and troubleshooting.
