3 ms·
Cloud Firestore has too many limitations on what it can't do... e.g. can't query with age > 10 and have it sorted by age <-- (wrong example) edit: see benjami
by devdoomari 9y ago
Cloud Firestore has too many limitations on what it can't do...
e.g. can't query with age > 10 and have it sorted by age <-- (wrong example)
edit: see benjaminl's comment on the wrong example
CORRECT example:
can't query with age > 10 and have it sorted by total_spent
- deleted 9y ago[deleted]
- benjaminl 9y agoFirebase Cloud Firestore is new product from Firebas and is much more flexible than Firebase Realtime Databse. It can do accomplish that query. From the docs a similar query: citiesRef .where("population", ">", 100000) .orderBy("population") .limit(2) https://firebase.google.com/docs/firestore/query-data/order-limit-data https://firebase.google.com/docs/firestore/query-data/order-...
- devdoomari 9y agoif you scroll down: citiesRef.where("population", ">", 100000).orderBy("country") is invalid... EDIT: sorry got confused & posted wrong example (population/population vs population / country)
- benjaminl 9y agoThat is interesting. The examples show this limitation. > Invalid: Range filter and first orderBy on different fields But I can’t find any documentation on what exactly the limitations on orderBy are. The reference docs on queries don’t mention any limitations on order_by: https://cloud.google.com/firestore/docs/reference/rpc/google.firestore.v1beta1#google.firestore.v1beta1.StructuredQuery https://cloud.google.com/firestore/docs/reference/rpc/google...