Ordenar y limitar consultas de Firestore con un filtro
Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
Ordenar y limitar consultas de Firestore con un filtro
Explora más
Para obtener documentación en la que se incluye esta muestra de código, consulta lo siguiente:
Muestra de código
Salvo que se indique lo contrario, el contenido de esta página está sujeto a la licencia Atribución 4.0 de Creative Commons, y los ejemplos de código están sujetos a la licencia Apache 2.0. Para obtener más información, consulta las políticas del sitio de Google Developers. Java es una marca registrada de Oracle o sus afiliados.
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Información o código de muestra incorrectos","incorrectInformationOrSampleCode","thumb-down"],["Faltan la información o los ejemplos que necesito","missingTheInformationSamplesINeed","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Otro","otherDown","thumb-down"]],[],[[["\u003cp\u003eFirestore queries can be filtered to retrieve data based on specific criteria, such as selecting cities with a population greater than 2,500,000.\u003c/p\u003e\n"],["\u003cp\u003eThe order of results in a Firestore query can be customized using the \u003ccode\u003eOrderBy\u003c/code\u003e function, demonstrated in the example of sorting cities by population.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eLimit\u003c/code\u003e function in Firestore allows you to restrict the number of results returned by a query, as shown in the examples by limiting the output to the top two cities.\u003c/p\u003e\n"],["\u003cp\u003eTo use Firestore, it's required to first authenticate by setting up Application Default Credentials, following the local development environment setup guide provided.\u003c/p\u003e\n"],["\u003cp\u003eThe provided code examples demonstrate how to use filters, order and limits on queries within the following languages: C#, Go, Java, Node.js, PHP, Python, and Ruby.\u003c/p\u003e\n"]]],[],null,["# Ordering and limiting Firestore queries with a filter\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\n .WhereGreaterThan(\"Population\", 2500000)\n .OrderBy(\"Population\")\n .Limit(2);\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 := cities.Where(\"population\", \"\u003e\", 2500000).OrderBy(\"population\", firestore.Desc).Limit(2)\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.whereGreaterThan(\"population\", 2500000L).orderBy(\"population\").limit(2);\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 biggestRes = await citiesRef.where('population', '\u003e', 2500000)\n .orderBy('population').limit(2).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\n -\u003ewhere('population', '\u003e', 2500000)\n -\u003eorderBy('population')\n -\u003elimit(2);\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 = (\n cities_ref.where(filter=FieldFilter(\"population\", \"\u003e\", 2500000))\n .order_by(\"population\")\n .limit(2)\n )\n results = query.stream()\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.where(\"population\", \"\u003e\", 2_500_000).order(\"population\").limit(2)\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)."]]