Filtering Database Views

1. What Are Filters?

Filters are rules you apply to a database view to hide entries that don't meet your criteria. The original data is never deleted; it's simply hidden from that specific view. This allows you to have one central database (a single source of truth) and create dozens of unique, focused views from it.

Think of it like sifting for gold. Your database is the entire riverbed full of rocks, silt, and gold. A filter is the pan that helps you isolate only the valuable nuggets you're looking for at that moment.

Every filter is built on a simple structure:
Property → Condition → Value

For example:

• Status (Property) → is (Condition) → Done (Value)
• Due Date (Property) → is on or before (Condition) → Today (Value)
• Priority (Property) → is not (Condition) → Low (Value)

To get a solid foundation on the concept and mechanics of filters, let's start with a comprehensive written guide.

2. Simple Filters: Your First Step to a Smarter View

A simple filter involves applying a single rule to a database view. This is the most common type of filtering you'll do.

Let's see it in action. This short video will walk you through creating your first filter.

The conditions available in the filter menu change depending on the property type. For example:

• A Text property will offer conditions like contains, does not contain, starts with.
• A Number property has greater than, less than, is equal to.
• A Date property includes powerful relative options like is today, is within the next week, or is in the past month.

3. Advanced Filters: Combining Rules with AND / OR Logic

The real power of filters is unlocked when you start combining rules. Notion allows you to do this in two ways:

1. AND Logic: Shows entries that match all the filter rules. This narrows down your results.

   • Example: Show tasks where Priority is High AND Status is Not Started.

2. OR Logic: Shows entries that match any of the filter rules. This broadens your results.

   • Example: Show content where Platform is Blog OR Platform is Newsletter.

When you add multiple simple filters, they are linked by AND logic by default. To use OR logic or create more complex combinations, you need to use an advanced filter. Advanced filters also allow you to create filter groups, which let you nest rules to build highly specific logic.

This official video from Notion provides an excellent walkthrough of building an advanced filter from scratch.

For a deeper dive into the "why" and "how" of filter groups, the Thomas Frank guide has another excellent section with practical examples.

4. Filters for Professional Template Design

Applying filters correctly is what separates a basic template from a professional, sellable one. Here are two key concepts you must master:

A. Saving Filters for Everyone

When you create a filter in a shared database (or a template you intend to share), you must click "Save for everyone". If you don't, the filter will only apply to your view, and your customer will see an unfiltered, confusing database.

B. Forcing Functions

This is a powerful technique where a filter pre-fills properties for new entries created in that view. For instance, if you have a view filtered for Status is "Idea", any new page you create in that view will automatically have its status set to "Idea". This creates a much smoother user experience.

The Thomas Frank guide has a fantastic explanation of this concept.

✍️ Exercise: Create Focused Task Views

Let's apply what you've learned. Imagine you have a master Tasks database for a project. Your goal is to create two new, filtered views for a dashboard.

Setup:

1. Create a new page and add a Table - Full page database. Name it All Tasks.
2. Add the following properties:
   • Status (Select): With options Not Started, In Progress, Done.
   • Priority (Select): With options High, Medium, Low.
   • Due Date (Date).
3. Add 5-7 sample tasks with a mix of different statuses, priorities, and due dates (including some for today, this week, and next week).

Your Tasks:

• 1. Create a "Today's Focus" View

  • Duplicate the default table view and rename it Today's Focus.
  • Apply a filter where Due Date is Today.
  • Apply a second filter where Status is not Done.
  • Ensure both rules are connected by AND.
  • Click "Save for everyone".

• 2. Create a "High-Impact" View

  • Create another new view (or duplicate the original) and name it High-Impact.
  • Apply an advanced filter to show tasks that meet the following criteria:
    • (Priority is High AND Status is not Done) OR (Due Date is Today AND Status is not Done)
  • This will require a filter group to correctly nest the AND and OR logic.
  • Click "Save for everyone".

This exercise mimics exactly how you would build a functional dashboard for a project management template.

Conclusion

You have now learned how to wield one of the most transformative features in Notion. Filters are the bridge between a simple data repository and an intelligent, dynamic system. By mastering them, you can create views that are perfectly tailored to a specific context, which is the hallmark of a high-value Notion template.

Key Takeaways:

• Filters Hide, Not Delete: They control which entries are visible in a specific view without altering the source database.
• Simple vs. Advanced: Simple filters apply one rule, while advanced filters combine multiple rules with AND and OR logic.
• Filter Groups for Complexity: Use filter groups to nest rules and create precise, sophisticated logic.
• Save for Everyone is Crucial: This ensures your filtered views work as intended when you share or sell your template.
• Forcing Functions Create Magic: Use filters to pre-fill properties on new entries, making your templates smarter and easier to use.

Preview of the Next Lesson:
We've figured out what to show. Next, we'll control the order in which it's shown. In the next lesson, we will cover sorting, which allows you to arrange your database entries by priority, due date, name, or any other property, adding another layer of organization to your views.