Database Views¶
Database Views let you create filtered, sorted views of your notes — like saved searches with a spreadsheet-style interface.
Opening Database Views¶
Press Cmd+Shift+D to open a Database View.
Creating Views¶
A Database View displays notes matching your filter criteria. You can filter by:
- Tags
- Front matter properties
- Date ranges (created, modified)
- Task status (has tasks, has overdue tasks)
- Favourite status
Columns¶
Database Views show notes in a table with configurable columns:
- Title
- Created date
- Modified date
- Tags
- Task count
- Custom properties
Creating and Saving Views¶
Click New in the Database View toolbar to create a view. Configure your filters and columns, then save. Views are stored in .views/ in your collection.
If you modify a saved view's filters or columns, an unsaved changes indicator appears. You can save the changes or revert to the saved version.
You can also create Database Views from context menus — right-click a tag in the sidebar to create a view filtered to that tag.
Interaction¶
Click a note in the view to open it in the editor. Sort by clicking column headers. The view updates live as you edit notes.
The collection name appears in the view's title bar when you have multiple collections, helping you know which collection you're querying.