firebase - Firestore order by two fields in one query

Question

I asked a question a little over a week ago. Firestore order by two fields

The response I got said that:

"The API supports the capability you want, although I don't see an example in the documentation that shows it.

The ordering of the query terms is important. Suppose you have a collection of cities and the fields of interest are population (h1) and name (h2). To get the cities with population in range 1000 to 2000, ordered by name, the query would be:

citiesRef.orderBy("population").orderBy("name").startAt(1000).endAt(2000)

This query requires a composite index, which you can create manually in the console. Or as the documentation there indicates, the system will help you:"

***But what this returns is not cities with population between 1000 and 2000 ordered by name but rather cities with population 1000 ordered by name followed by cities with population 1001 ordered by name followed by 1002 ordered by name and so on up to 2000.

I wondering if there is a way to get all cities between 1000 and 2000 in population ordered by name. Thanks.

Answer 1

Waitting for answers