Improve notion's filterring

[Shirobachi]

The idea is:

So the notion node has method get all what have filtering and sorting, the filtering missing something

My use case:

I couldn’t filter pages with two level deep like
if A and (B or C)
more here: I am confused about notion filter grouping

I think it would be beneficial to add this because:

sometimes it’s impossible to get what you want with one level deep, and it’s better for performant to use notion API for filtering instead get all and filter with function node

Any resources to support this?

Please have a look how notion updated docs describe this: Query a database

Are you willing to work on this?

I am about to start working on n8n but this tasks sound for me like too big

[RicardoE105]

In version 2, you will be able to provide your “own” filters, meaning you can make them as complex as you want. That should be available soon.

You can test it right now using the following docker image.

docker run -it --rm --name n8n -p 5678:5678 -v ~/.n8n:/home/node/.n8n n8nio/n8n:PR-2437-feature-notion-v2

[Shirobachi]

This is awesome idea, will resolve both my problems with filter <3

Notion filter of formula

I would like ask if would be possible to add filter for notion’s pages’s property type formula since notion give that possibility: Query a database n8n: [image] Thank you in advance!

[RicardoE105]

Ahh you can also now filter fields type formula.

[Shirobachi]

I cannot pull this image but I am very happy that it’s about to be real <3 Thank you guys!