Logical Operators combining two ANDS with an OR

[wyndhurst]

https://www.anon.com/api/note?and=(created.gte.2024-12-01,created.lte.2025-02-28) This Date range Works
https://www.anon.com/api/note?and=(id.gte.2,id.lte.5) This Id range Works

When I combine them with the ampersand between the two conditions:
https://www.anon.com/api/note?and=(created.gte.2024-12-01,created.lte.2025-02-28)&and=(id.gte.2,id.lte.5) This works in the sense that both conditions have to be met. An implicit AND.

However, I have failed to create an OR. I want records in the date range OR records which are in the Id range.

Any ideas? Your help would be greatly appreciated!

[wolfgangwalther]

You can nest those operators:

https://www.anon.com/api/note?or=(and(created.gte.2024-12-01,created.lte.2025-02-28),and(id.gte.2,id.lte.5))

There is also an example of that in https://docs.postgrest.org/en/v12/references/api/tables_views.html#logical-operators.

[wyndhurst]

That works! And is logical. Thank you so much for saving my hair. 10/10