An example of an invalid order and limit Firestore query

An example of an invalid order and limit Firestore query

Code sample

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

Query query = citiesRef
    .WhereGreaterThan("Population", 2500000)
    .OrderBy("Country");

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

// Note: This is an invalid query. It violates the constraint that range
// and order by are required to be on the same field.
query := cities.Where("population", ">", 2500000).OrderBy("country", firestore.Asc)

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

Query query = cities.whereGreaterThan("population", 2500000L).orderBy("country");

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

citiesRef.where('population', '>', 2500000).orderBy('country');

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.where(filter=FieldFilter("population", ">", 2500000)).order_by(
    "country"
)
results = query.stream()

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

query = cities_ref.where("population", ">", 2_500_000).order("country")

What's next

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