Notion search objects filter on roll up error

[Clement_Herve]

Hello,

When I’m using notion search objects and I set a filter on roll up, then I get an error.

I’m trying to find people who are concerned by an event.

I have an Event Database, a club database and a member database.

When a new event is created, clubs concerned by this event are linked to the event.

With the automation, when a new event is created, i’m looking for the members concerned (regarding the club) to send the invitation.

So I’m checking if Event’s name is one of the events where the member is linked.

RuntimeError

[400] body failed validation. Fix one: body.filter.or[0].rollup.any should be defined, instead was undefined.

[Simo]

Hi Clément,
It seems that Make currently doesn’t support filtering by a rollup property, which is the reason for the error.

So, one solution option is to use the “Make an API call” Notion module and call the “Query a database” endpoint, constructing your own filter body using the Rollup filter data structure you can find here.

Then, you can use an Iterator module to loop through the Results array.

[Clement_Herve]

Thanks @Simo for your help.

I tried the “Make an API call” module but I can’t find the members linked to the event as you can see on the screenshots. Do you have an idea of where I’m wrong ?

Database ID is my members database ID.

Thanks,
Clément

[Simo]

It looks like “Event invités” is not a text property but it outputs pages. You could try using another property of formula type that uses the “format()” function to turn those into text, and then filter by that new property