Date‐based filters for table databases (this week / next week)

[NorkzYT]

I would love to be able to filter an Affine table by “this week” or “next week” dates—like Notion does. Currently I do not see any way to do that today, and would be happy to work on a PR to add it.

Below are examples from Notion:

Affine example:

[NorkzYT]

I am noting this link down here for myself as it seems to have what I am looking for:

AFFiNE/packages/frontend/core/src/modules/collection-rules/impls/filters/date.ts

Line 55 in 9220b97

if (method === 'is-empty' || method === 'is-not-empty') {

[NorkzYT]

Found the actual file to add to here:

AFFiNE/blocksuite/affine/data-view/src/core/filter/filter-fn/date.ts

Line 10 in cf456c8

name: 'before',

[NorkzYT]

@EYHN

It would be great if you could help as I am working on a PR to be able to add the above features that Notion has of Table Database Date Filtering.

I tried for many hours changing and looking in the following folders and have not been able to change the "Before" dropdown button; much less add a new dropdown button to the right side of it.

        "frontend/core/src/modules/collection-rules/impls/filters",
        "packages/frontend/component/src/ui/date-picker",
        "blocksuite/affine/components/src/context-menu",
        "blocksuite/affine/data-view/src/core/filter/filter-fn"

Can you point me in the right direction?

[NorkzYT]

I have figured it out.

[NorkzYT]

Made a PR for this:
#12619