Interroger une collection Firestore à l'aide de plusieurs filtres "égal à"
Restez organisé à l'aide des collections
Enregistrez et classez les contenus selon vos préférences.
Interroger une collection Firestore à l'aide de plusieurs filtres "égal à"
En savoir plus
Pour obtenir une documentation détaillée incluant cet exemple de code, consultez les articles suivants :
Exemple de code
Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Difficile à comprendre","hardToUnderstand","thumb-down"],["Informations ou exemple de code incorrects","incorrectInformationOrSampleCode","thumb-down"],["Il n'y a pas l'information/les exemples dont j'ai besoin","missingTheInformationSamplesINeed","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Autre","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis document provides code samples demonstrating how to query a Firestore collection using multiple equality filters across various programming languages.\u003c/p\u003e\n"],["\u003cp\u003eThe examples showcase how to chain \u003ccode\u003eWhereEqualTo\u003c/code\u003e or \u003ccode\u003ewhere\u003c/code\u003e methods to filter data based on multiple criteria, such as state and name, or state and population.\u003c/p\u003e\n"],["\u003cp\u003eEach code sample, in C#, Go, Java, Node.js, PHP, Python, and Ruby, includes instructions to set up Application Default Credentials for Firestore authentication.\u003c/p\u003e\n"],["\u003cp\u003eThe content directs users to additional resources for detailed documentation on simple and compound queries in Cloud Firestore.\u003c/p\u003e\n"]]],[],null,["# Query a Firestore collection with multiple eq filters\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Perform simple and compound queries in Cloud Firestore](https://firebase.google.com/docs/firestore/query-data/queries)\n- [Query and filter data](/firestore/native/docs/query-data/queries)\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 CollectionReference citiesRef = db.Collection(\"cities\");\n Query chainedQuery = citiesRef\n .WhereEqualTo(\"State\", \"CA\")\n .WhereEqualTo(\"Name\", \"San Francisco\");\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 denverQuery := cities.Where(\"name\", \"==\", \"Denver\").Where(\"state\", \"==\", \"CO\")\n caliQuery := cities.Where(\"state\", \"==\", \"CA\").Where(\"population\", \"\u003c=\", 1000000)\n query := cities.Where(\"country\", \"==\", \"USA\").Where(\"population\", \"\u003e\", 5000000)\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 chainedQuery1 = cities.whereEqualTo(\"state\", \"CO\").whereEqualTo(\"name\", \"Denver\");\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 citiesRef.where('state', '==', 'CO').where('name', '==', 'Denver');\n citiesRef.where('state', '==', 'CA').where('population', '\u003c', 1000000);\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 $chainedQuery = $citiesRef\n -\u003ewhere('state', '=', 'CA')\n -\u003ewhere('name', '=', 'San Francisco');\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\n denver_query = cities_ref.where(filter=FieldFilter(\"state\", \"==\", \"CO\")).where(\n filter=FieldFilter(\"name\", \"==\", \"Denver\")\n )\n large_us_cities_query = cities_ref.where(\n filter=FieldFilter(\"state\", \"==\", \"CA\")\n ).where(filter=FieldFilter(\"population\", \"\u003e\", 1000000))\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 chained_query = cities_ref.where(\"state\", \"=\", \"CA\").where(\"name\", \"=\", \"San Francisco\")\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)."]]