在多个字段上对 Firestore 查询进行排序
使用集合让一切井井有条
根据您的偏好保存内容并对其进行分类。
在多个字段上对 Firestore 查询进行排序
深入探索
如需查看包含此代码示例的详细文档,请参阅以下内容:
代码示例
如未另行说明,那么本页面中的内容已根据知识共享署名 4.0 许可获得了许可,并且代码示例已根据 Apache 2.0 许可获得了许可。有关详情,请参阅 Google 开发者网站政策。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 page demonstrates how to order Firestore queries by multiple fields, providing code examples in various languages.\u003c/p\u003e\n"],["\u003cp\u003eThe examples provided show how to use \u003ccode\u003eOrderBy()\u003c/code\u003e or similar methods to sort data by fields such as "state" and "population," with options for ascending or descending order.\u003c/p\u003e\n"],["\u003cp\u003eEach code sample requires setting up Application Default Credentials for Firestore authentication, with a link for guidance.\u003c/p\u003e\n"],["\u003cp\u003eThe examples cover languages such as C#, Go, Java, Node.js, PHP, Python, and Ruby, demonstrating the flexibility of Firestore.\u003c/p\u003e\n"],["\u003cp\u003eThe examples use a collection of cities as its basis, showing us how to order the cities based on their state and population.\u003c/p\u003e\n"]]],[],null,["# Ordering a Firestore query on multiple fields\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Order and limit data](/firestore/native/docs/query-data/order-limit-data)\n- [Order and limit data with Cloud Firestore](https://firebase.google.com/docs/firestore/query-data/order-limit-data)\n\nCode sample\n-----------\n\n### C#\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 Query query = citiesRef.OrderBy(\"State\").OrderByDescending(\"Population\");\n\n### Go\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 query := client.Collection(\"cities\").OrderBy(\"state\", firestore.Asc).OrderBy(\"population\", firestore.Desc)\n\n### Java\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 Query query = cities.orderBy(\"state\").orderBy(\"population\", Direction.DESCENDING);\n\n### Node.js\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 const byStateByPopRes = await citiesRef.orderBy('state').orderBy('population', 'desc').get();\n\n### PHP\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 $query = $citiesRef-\u003eorderBy('state')-\u003eorderBy('population', 'DESC');\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 ordered_city_ref = cities_ref.order_by(\"state\").order_by(\n \"population\", direction=firestore.Query.DESCENDING\n )\n\n### Ruby\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 query = cities_ref.order(\"state\").order(\"population\", \"desc\")\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)."]]