Ordering and limiting Firestore queries

Ordering and limiting Firestore queries

Explore further

For detailed documentation that includes this code sample, see the following:

Code sample

C#

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

Query query = citiesRef.OrderBy("Name").Limit(3);

Go

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

query := cities.OrderBy("name", firestore.Asc).Limit(3)
query := cities.OrderBy("name", firestore.Asc).LimitToLast(3)

Java

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

Query query = cities.orderBy("name").limit(3);
Query query = cities.orderBy("name").limitToLast(3);

Node.js

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

const firstThreeRes = await citiesRef.orderBy('name').limit(3).get();

PHP

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

$query = $citiesRef->orderBy('name')->limit(3);

Python

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

cities_ref = db.collection("cities")
query = cities_ref.order_by("name").limit_to_last(2)
results = query.get()

Ruby

To authenticate to Firestore, set up Application Default Credentials. For more information, see Set up authentication for a local development environment. 

query = cities_ref.order("name").limit(3)

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.