[Feature Request]: Database Views

[tiagosales]

Description

It would be great if we could use database views across different pages, linking to an existing database (table).

Use case

Suppose we want to create a project based on a template and view only tasks assigned to this specific project on the page. I have a tasks database page with a table containing tasks for all my projects. On the project page, I want to see only tasks for that specific project, using the view linked to a tasks database but displaying only the tasks relevant to this project.

Anything else?

In Notion, it would be equivalent to creating a new table on a new page and linking it to an existing database, allowing you to create as many specific views as you want without affect the database itself.

If this feature already exists, please let me know, as I couldn't find a way to use it.

https://www.notion.com/help/data-sources-and-linked-databases

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!

[affine-issue-bot]

Issue Status: 🆕 *Untriaged

*🆕 Untriaged

The team has not yet reviewed the issue. We usually do it within one business day.
Docs: https://github.com/toeverything/AFFiNE/blob/canary/docs/issue-triaging.md

^{_{This is an automatic reply by the bot.}}

[hwangdev97]

Yep, that's exactly the functionality we're aiming for!

But right now, we're mainly focused on squashing bugs, boosting performance, and making the database architecture more stable. We'll start rollin' out these features gradually in future updates.