Skip to content
Tutorials Center
My learning

Topics

Lesson 13 of 36 ยท Databases

Filters, Sorts and Groups

Control which Notion database rows you see with filters, filter groups, AND/OR logic, multi-level sorts and grouping, and save the setup as a reusable view.

A database with fifty rows is easy to read. One with five thousand is not. Filters, sorts and groups let each view show only the rows you care about in an order that makes sense. They do not change data; they change what a particular view displays.

Where the controls are

Above a database view you will find buttons (icons or labels depending on window width): Filter, Sort, and the ... or Group menu. They apply only to the view you are in. Notion marks a modified view with a blue dot until you save the change (Save for everyone or reset), so you can experiment without altering the saved layout.

Three controls, three jobs

Filter Hide rows that don't match.
Sort Set the order of rows.
Group Cluster rows under headings.
1 / 2

Filters

A filter rule has three parts: a property, a condition and a value. Conditions depend on the property type:

  • Text: contains, does not contain, is, is empty, starts with.
  • Number: =, โ‰ , >, <, โ‰ฅ, โ‰ค, is empty.
  • Select and Status: is, is not, is empty.
  • Multi-select: contains, does not contain.
  • Date: is, before, after, on or before, is within (past week, next month), and relative values like "Today".
  • Checkbox: is checked, is not checked.
  • Person: contains, does not contain, and the special value Me.

The relative date and Me values are what make views reusable: "Assignee contains Me and Due is within the next week" shows each viewer their own upcoming tasks.

AND, OR and groups

Add more rules with + Add filter rule. By default, rules combine with And: every rule must match. Change the connector to Or to match any rule. + Add filter group creates nested logic, such as "Status is not Done AND (Priority is High OR Due is today)". Notion allows several nesting levels, but readable views usually need only one.

Sorts

Click Sort, choose a property and a direction (ascending or descending). Add more sorts to break ties: sort by Priority, then by Due date. Order of the sort rules matters; the first rule is the primary key. Select properties sort by their option order, not alphabetically, so reorder options if High should come before Low.

Groups

Group by collects rows under headings: by Status, Select, Person, Date (by day, week, month, year) or another property. Table, list and gallery views can group; a board is always grouped. Groups can be collapsed, hidden when empty, and ordered manually or alphabetically.

Saving work

Changes you make to a filter or sort in a shared view show a prompt: Save for everyone, Reset, or in some versions Save as new view. Leave the base view neutral and create named views ("My tasks", "Overdue") with the filters baked in.

Simulating filters and sorts

This stand-in implements AND filter rules, a two-level sort and a group-by over rows. It models the logic; Notion's implementation is much richer.

JS Filter, sort and group (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

JS AND versus OR (stand-in)

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Practical views to build

  1. My tasks: Assignee contains Me, Status is not Done, sorted by Due ascending.
  2. Overdue: Due is before Today, Status is not Done.
  3. This week: Due is within the next week.
  4. Unassigned: Assignee is empty.

If a filter seems to hide rows wrongly, check for stray extra rules, an OR where you wanted AND, and for date filters on rows that have no date; empty values usually do not match "before" or "after".

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which special filter value lets one view show each viewer their own items?

    Using Me with a Person property shows the current viewer's items in a shared view.
  2. 2. What happens by default when you add several filter rules?

    The default connector is And; you can switch it to Or or use filter groups.
  3. 3. How do Select properties sort?

    Select properties follow the order of their options, which you can rearrange.
  4. 4. Do filters change the underlying data?

    Filters affect the display only; the rows remain in the database.

Summary

  • Filters combine property, condition and value; combine rules with AND, OR and groups.
  • Sorts apply in order, so the first is primary.
  • Group by clusters rows under headings.
  • Build named views that carry their filters instead of editing one view repeatedly.

Next: Linked Databases and Views