Filtering and pagination with multiple terms

[ptpaterson]

Removed previous reply, since it was not correct.

This is a better discussion to point to:

Indexing on Dates, Conflict-Checking for Appointments

I think you should be fine by just checking with Exists and Match whether such a calendar item already exists or not. Sidenote on consistency Just to be clear, since there is a discussion in slack that was slightly inaccurate where the question was: “is this safe in FaunaDB”, in some (or quite a few) databases the approach I’m going to explain exposes you to a phenomenon called: Phantom reads. FaunaDB protects you against these anomalies as it has one of the highest consistency guarantees (and…

How to query by multiple conditions in faunadb?