• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

  • Due to Diwali and Bhai Dooj celebrations, our team will have limited availability. While we’ll continue to monitor threads, responses may be slightly delayed. Normal operations will resume on Friday, 24th October 2025.

Need Help with Notion Query a Database Action

Fagun Shah

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

Pabbly Account Email - [email protected]

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

1655808181839.png
 

Hermes

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

PabblyMember3

Guest
@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:

Code:
{ "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
 
Top