# Filter error Notion get many node

**URL:** <https://community.n8n.io/t/filter-error-notion-get-many-node/31223>\
**Category:** Questions\
**Tags:** notion\
**Created:** [October 5, 2023, 10:04am UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223 "2023-10-05T10:04:16Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sssamsss8](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@sssamsss8](https://community.n8n.io/u/sssamsss8)\
**Post date:** [October 5, 2023, 10:04am UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/1 "2023-10-05T10:04:16Z")

</div>

Hi,  
I have this error when a use the get many database pages node with a filter :

 ![Capture d’écran 2023-10-05 à 12.03.31](https://europe1.discourse-cdn.com/n8n/original/3X/6/f/6f6d3e6faee53927e22205d7b8b4fdb976237d61.png)

is it a bug ? Or am I doing something wrong ?

Thank you

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [October 5, 2023, 2:59pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/3 "2023-10-05T14:59:58Z")

</div>

Hi @sssamsss8 👋 I’m not too sure what’s happening here, can you share your full workflow so we can take a more in-depth look? But it does look like there’s something that isn’t getting the data that it should through an expression, by the error 🤔

---

<div class="post-metadata">

**Author:** ![sssamsss8](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@sssamsss8](https://community.n8n.io/u/sssamsss8)\
**Post date:** [October 5, 2023, 3:05pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/4 "2023-10-05T15:05:46Z")

</div>

The workflow was very simple :

I’m on n8n cloud 1.8.2

---

<div class="post-metadata">

**Author:** ![sssamsss8](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@sssamsss8](https://community.n8n.io/u/sssamsss8)\
**Post date:** [October 5, 2023, 3:09pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/5 "2023-10-05T15:09:04Z")

</div>

My workaround was to get all the pages in the Notion database and then I put a Code Node to filter the items (pages) directly with Javascript code. It works this way. But still, it looks like the filtering directly in the get many node did not work.

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [October 5, 2023, 3:40pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/6 "2023-10-05T15:40:57Z")

</div>

Hi @sssamsss8 👋 Did a little bit of testing - I think the `|` character in your filter/table is what’s causing this error. Once I removed it after creating that column and filtering for it, I was able to filter the results correctly.

I’m not too sure if this is expected, so I’ll go ahead and let our developers know this is happening 🙇‍♂️

---

<div class="post-metadata">

**Author:** ![sssamsss8](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@sssamsss8](https://community.n8n.io/u/sssamsss8)\
**Post date:** [October 5, 2023, 3:55pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/8 "2023-10-05T15:55:00Z")

</div>

If I remove de | it is no longer possible to filter on the property I wanted. Maybe it is because this property is a “formula” property in Notion ??  
Just guessing …

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [October 5, 2023, 3:59pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/9 "2023-10-05T15:59:47Z")

</div>

That might be the case - I’m not sure of another workaround for the moment, but I’ve let our development team know about this, and I’ll ping you back with any updates when I have them 🙇‍♂️

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [January 3, 2024, 3:59pm UTC](https://community.n8n.io/t/filter-error-notion-get-many-node/31223/10 "2024-01-03T15:59:47Z")

</div>

Closed on January 3, 2024, 3:59pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
