Need Help with Notion Query a Database Action

[Fagun Shah]

Workflow - https://connect.pabbly.com/workflow/mapping/IjQxODI4NCI_3D

Pabbly Account Email - [email protected]

Notion DB Link - https://integrationlab.notion.site/integrationlab/Pabbly-93918f4d515044c6b1b4a06801f58f19

 

[Hermes]

{ "and": [{ "property":"Subject", "rich_text": {"contains":"Subject" }}, { "property":"Marks", "number": { "greater_than":200} }] }

 

[PabblyMember3]

@Fagun Shah we have checked your workflow and found that the filter condition was wrong that you were trying.

Here is the correct filter condition:

{ "or": [ { "property": "Subject", "rich_text": { "contains": "Subject" } }, { "and": [ { "property": "Marks", "number": { "greater_than": 200 } }, { "property": "Marks", "number": { "less_than": 300 } } ] } ] }

Note: "contains" will not work on numbers you can use greater_than or less_than instead.

We have also created a workflow in your account with above filter condition which is working fine: https://connect.pabbly.com/workflow/mapping/IjQxODUwNSI_3D