[devdoomari]

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

[benjaminl]

Firebase 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-...

[devdoomari]

if you scroll down:

citiesRef.where("population", ">", 100000).orderBy("country")

is invalid...

EDIT: sorry got confused & posted wrong example (population/population vs population / country)