順序和限制無效的 Firestore 查詢示例 (非同步)
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
順序和限制無效的 Firestore 查詢示例 (非同步)。
程式碼範例
Python
如要向 Firestore 進行驗證,請設定應用程式預設憑證。
詳情請參閱「為本機開發環境設定驗證」。
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","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)."]]