Notion search objects filter empty date

Hi,

I have a Notion database with items, that include a Creation Date property.

My goal is to use Make.com to query the database and search for items where the Creation Date is empty.

I have a “Notion - Search Objects” module in make, and I apply the following filter:

Screenshot 2024-02-24 at 07.52.18

When executing the module, throws the following error:

RuntimeError

[400] body failed validation. Fix one: body.filter.or[0].date.equals should be defined, instead was undefined. body.filter.or[0].date.before should be defined, instead was undefined. body.filter.or[0].date.after should be defined, instead was undefined. body.filter.or[0].date.on_or_before should be defined, instead was undefined. body.filter.or[0].date.on_or_after should be defined, instead was undefined. body.filter.or[0].date.this_week should be defined, instead was undefined. body.filter.or[0].date.past_week should be defined, instead was undefined. body.filter.or[0].date.past_month should be defined, instead was undefined. body.filter.or[0].date.past_year should be defined, instead was undefined. body.filter.or[0].date.next_week should be defined, instead was undefined. body.filter.or[0].date.next_month should be defined, instead was undefined. body.filter.or[0].date.next_year should be defined, instead was undefined. body.filter.or[0].date.is_empty should be true, instead was "". body.filter.or[0].date.is_not_empty should be defined, instead was undefined.

Origin

Notion

How to fix this one? Any help appreciated!!

Add {{true}} to the second white box in the screenshot. That is because this filter is using a boolean condition, so we need a corresponding boolean operator (true or false)
image

6 Likes

Ah, of course, it works now, thanks!! :laughing:

2 Likes