An example of an invalid order and limit Firestore query (async)
Stay organized with collections
Save and categorize content based on your preferences.
An example of an invalid order and limit Firestore query (async).
Code sample
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis code example demonstrates an invalid Firestore query that attempts to filter by population and order the results by country.\u003c/p\u003e\n"],["\u003cp\u003eThe provided query will not work because it combines a filter operation with an order operation on different fields, which is not supported by Firestore.\u003c/p\u003e\n"],["\u003cp\u003eAuthentication to Firestore is required and can be set up using Application Default Credentials.\u003c/p\u003e\n"],["\u003cp\u003eThe Google Cloud sample browser contains additional code examples for searching and filtering on various Google Cloud products, including Firestore.\u003c/p\u003e\n"]]],[],null,["# An example of an invalid order and limit Firestore query (async).\n\nCode sample\n-----------\n\n### Python\n\n\nTo authenticate to Firestore, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n cities_ref = db.collection(\"cities\")\n query = cities_ref.where(filter=FieldFilter(\"population\", \"\u003e\", 2500000)).order_by(\n \"country\"\n )\n results = query.stream()\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=firestore)."]]