Firestore Order and Limit Data - tuarua/Firebase-ANE GitHub Wiki

The contents of this page are based on the original Firebase Documentation

Cloud Firestore provides powerful query functionality for specifying which documents you want to retrieve from a collection. These queries can also be used with either getDocument() or addSnapshotListener(), as described in Get Data.

Order and limit data

Cloud Firestore also lets you specify the sort order for your data and specify a limit to how many documents you want to retrieve using order() and limit(). For example, you could query for the first 3 cities alphabetically with:

citiesRef.order("name").limit(3);

You could also sort in descending order to get the last 3 cities:

citiesRef.order("name", true).limit(3);

You can also order by multiple fields. For example, if you wanted to order by state, and within each state order by population in descending order:

citiesRef.order("state").order("population", true);

You can combine where() filters with order() and limit(). In the following example, the queries define a population threshold, sort by population in ascending order, and return only the first few results that exceed the threshold:

citiesRef.where("population", ">", 100000).order("population").limit(2);