newbie to firestore here and struggling with how to overcome the range filter on different fields limitation.
Use case is storage and retrieval of event/event data for a calendaring solution.
Calendar views can be different weeks, months etc, i,e each specific view has a defined start and end timestamp.
Stored events has a start timestamp and an end timestamp.
I need to query for all events that start, ends within or spans the views start and end timestamp.
Implementing this with a sql backend is trivial, but with firestore the range filter on different fields seems to make this impossible? Any ideas how this could be solved? Or if there as plans for supporting this kind of functionality in firestore?
BR Stefan
See Question&Answers more detail:os
