I’ve learned a lot by reading questions/answers from others in this forum, but have not been able to find this answer here. Apologies if it has been asked before.
I have a list of values in my app and a collection in Firestore that I want to match a particular field (goal_id) against the list of values in my app ([3, 5, 8, 25, etc…]). I can create a data variable that filters based on a single value, but am not sure how to create a filter based on a set of values (e.g. the equivalent of an “in” rather than an “=” query in SQL). I don’t want to query all the documents in this collection and filter as it could be a very large set eventually. Ideally, I’d like to just query for the documents that match my list.
Does anyone have a suggestion for how I would do this within Appgyver/Firebase?
I did find this documentation in Firebase (Cloud Firestore Now Supports IN Queries!), but have been using the Firebase integration of AppGyver which doesn’t have “in” as an option as far as I can see. But perhaps there is a way to do this with a formula? Or do I need to use the Rest API integration with Firebase?