Views, filters, sorts & groups

Uh-oh! It looks like your ad blocker is preventing the video from playing.

You can view the same database in multiple ways, and switch back and forth between them depending on your needs. Within a view, you can add filters and sorts to easily categorize your content 📁

There are six different ways to visualize your content within a database. Here's a high level overview of each layout:
Table: Tables allow you to see your database pages as rows, with every property represented by a column.
Board: This view groups your items by property. For example, you could use it as a Kanban board to move tasks from one status to another as you make progress on them.
Timeline: Use your database to plot project milestones on a timeline so you can see when they’re happening and how long they’ll take to complete.
Calendar: Calendar view displays your items based on their
Date
property.List: Lists are a very clean, minimal layout of your database items.
Gallery: This view is useful for highlighting images. You can edit your gallery to show images contained in the
Files & media
property — otherwise, the gallery will show any content that the database page contains.Chart: This view visualizes your database items in a bar, line, or donut chart so you can easily analyze and report on the data.
You can also create, share, and gather information using forms, which are connected to databases.
New databases are created as tables. After this, you can create a new view by selecting +
next to your database name or your existing database views. Depending on your screen size, you may have to click on the name of your current view and select New view
.
In the menu that appears, select a type of view. Then, give your view a name. You can click through your views to see your data in different ways.

You can reorder your views by dragging them. If you have a lot of views, you can select {#} more...
next to your views to do this.
In your sidebar, views show up as nested items inside any full page database. You can tell they are views because they'll have a •
to their left. Click on any view in your sidebar to jump right to it.

Note: Each database view has its own settings. Settings applied to one database view won’t be applied across all other database views automatically.
When you’re in a given view, click its name to rename, duplicate, delete, copy its link, or edit its components. You can also edit view components by clicking the settings menu at the top right of the database.

The settings menu has a section called View settings
. This menu contains the following options:
Layout: Choose how you want your database to be visually organized.
Property visibility: Show or hide database properties for each view.
Filter: Add criteria based on property values to show or hide data.
Sort: Sort by a property to change the order that pages are displayed in.
Group: Group your data by the values in a property.
Sub-group: Create a second layer of grouping within your existing groups. For example, groups by status can also be sub-grouped into priority.
Copy link to view: Get a direct link to the particular database view you’re in.
You can find more information on filters, sorts, and groups below.
Within each view, you can choose how you'd like database pages to open. There are three options:
Side peek: Open pages on the right side of the database. The rest of the database view continues to be interactive on the left.
Center peek: Open pages in a focused, center modal.
Full page: Open pages as full pages directly.
To change how pages open in a particular view:
Open the settings menu at the top of the database.
Select
Layout
.Open the menu next to
Open pages in
and select from one of the options.

Note: Table, Board, List & Timeline layouts will open pages in side peek by default. Gallery & Calendar layouts will open pages in center peek by default.
Notion makes it easy to filter your database so it only displays the items that meet specific criteria. These filters can be as simple or complex as you like!
Add a filter
To filter the entries you see in a database view:
Open the settings menu at the top of the database.
In the menu that appears, select
Filter
underView settings
.Choose the property you'd like to filter by.
You can choose to
Save for everyone
if you want the filter to be applied for everyone in the database view. If you want the filter to apply only for you, don’t select this option.
Add an advanced filter

Uh-oh! It looks like your ad blocker is preventing the video from playing.

You can create more specific database views and combine AND
and OR
logic by using filter groups. These can be nested up to three layers deep! Here's how:
Open the settings menu at the top of the database.
In the menu that appears, select
Filter
underView settings
→Add advanced filter
.In the menu that appears, choose the properties that you'd like to filter by, and customize the
AND
andOR
logic of the advanced filter.

Tip: You can turn a simple filter into an advanced one by opening the edit menu at the top of your database and selecting Filter
. Click on a particular filter and in the menu that appears, select •••
→ Add to advanced filter
.
Delete a filter
To delete a filter:
Open the settings menu at the top of the database.
In the menu that appears, select
Filter
underView settings
.Open the filter you want to delete and in the menu that appears, select
•••
→Delete filter
.
You can sort your database so that items are displayed based on properties appearing in ascending or descending order. For example, you can order database pages based on priority, when they were last edited, or alphabetically.
To sort your database:
Open the settings menu at the top of the database.
In the menu that appears, select
Sort
underView settings
.Choose the property you'd like to sort by.
You can choose to
Save for everyone
if you want the sort to be applied for everyone in the database view. If you want the sort to apply only for you, don’t select this option.Change the order that multiple sorts are applied by dragging them up or down using
⋮⋮
.

Note: Different properties sort by different logic, depending on their value type.
Text properties such as
Name
andText
sort alphabetically.Number properties sort numerically.
For
Select
andMulti-select
properties, you get to define what sorting order means. Click on the property, then drag options up or down to set the sort order.
Delete a sort
To delete a sort:
Open the settings menu at the top of the database.
In the menu that appears, select
Sort
underView settings
.Select
X
next to the sort you want to remove.
You can group your database by different properties on your table to visualize them in different ways. To do this:
Open the settings menu at the top of the database.
In the menu that appears, select
Group
underView settings
.Choose the property you'd like to group by.
The database will now group by values of that property. You can go to the settings menu and select Group
to:
Hide or show groups by selecting
👁️
to them.Sort
your groups manually or by the options provided (alphabetical, ascending, and more).Hide empty groups
.
Remove grouping
To turn grouping off:
Open the settings menu at the top of the database.
In the menu that appears, select
Group
underView settings
.Select
Remove grouping
.
Databases that contain at least three pages will also be searchable so you can easily parse through the information within them. To search a database, select 🔍
at the top of the database and enter a query. As you type, the database will only show pages that match your query. Database search looks at database page titles and properties.
If you have a large database, it's probably tedious to keep moving back and forth between properties to compare their data.
Instead you can freeze one column, which will cause it to stay visible on the left side no matter where you scroll in the database.
To freeze a column, click the name of the column and click
Freeze up to column
.To unfreeze a column, click the name of the column and click
Unfreeze column
.