Cloud Firestore 提供了強大的查詢功能,用於指定您要從集合中檢索哪些文檔。這些查詢也可以與get()
或addSnapshotListener()
一起使用,如獲取數據中所述。
訂單和限制數據
默認情況下,查詢會按文檔 ID 升序檢索滿足查詢的所有文檔。您可以使用orderBy()
指定數據的排序順序,並且可以使用limit()
限制檢索的文檔數量。
例如,您可以按字母順序查詢前 3 個城市:
Web version 9
import { query, orderBy, limit } from "firebase/firestore"; const q = query(citiesRef, orderBy("name"), limit(3));
Web version 8
citiesRef.orderBy("name").limit(3);
迅速
citiesRef.order(by: "name").limit(to: 3)
目標-C
[[citiesRef queryOrderedByField:@"name"] queryLimitedTo:3];
Kotlin+KTX
citiesRef.orderBy("name").limit(3)
Java
citiesRef.orderBy("name").limit(3);
Dart
final citiesRef = db.collection("cities"); citiesRef.orderBy("name").limit(3);
爪哇
Python
Python
C++
cities_ref.OrderBy("name").Limit(3);
節點.js
去
PHP
PHP
有關安裝和創建 Cloud Firestore 客戶端的更多信息,請參閱Cloud Firestore 客戶端庫。
統一
Query query = citiesRef.OrderBy("Name").Limit(3);
C#
紅寶石
您還可以按降序排序以獲得最後3 個城市:
Web version 9
import { query, orderBy, limit } from "firebase/firestore"; const q = query(citiesRef, orderBy("name", "desc"), limit(3));
Web version 8
citiesRef.orderBy("name", "desc").limit(3);
迅速
citiesRef.order(by: "name", descending: true).limit(to: 3)
目標-C
[[citiesRef queryOrderedByField:@"name" descending:YES] queryLimitedTo:3];
Kotlin+KTX
citiesRef.orderBy("name", Query.Direction.DESCENDING).limit(3)
Java
citiesRef.orderBy("name", Direction.DESCENDING).limit(3);
Dart
final citiesRef = db.collection("cities"); citiesRef.orderBy("name", descending: true).limit(3);
爪哇
Python
Python
C++
cities_ref.OrderBy("name", Query::Direction::kDescending).Limit(3);
節點.js
去
PHP
PHP
有關安裝和創建 Cloud Firestore 客戶端的更多信息,請參閱Cloud Firestore 客戶端庫。
統一
Query query = citiesRef.OrderByDescending("Name").Limit(3);
C#
紅寶石
您還可以按多個字段排序。例如,如果您想按州排序,並在每個州內按人口降序排序:
Web version 9
import { query, orderBy } from "firebase/firestore"; const q = query(citiesRef, orderBy("state"), orderBy("population", "desc"));
Web version 8
citiesRef.orderBy("state").orderBy("population", "desc");
迅速
citiesRef .order(by: "state") .order(by: "population", descending: true)
目標-C
[[citiesRef queryOrderedByField:@"state"] queryOrderedByField:@"population" descending:YES];
Kotlin+KTX
citiesRef.orderBy("state").orderBy("population", Query.Direction.DESCENDING)
Java
citiesRef.orderBy("state").orderBy("population", Direction.DESCENDING);
Dart
final citiesRef = db.collection("cities"); citiesRef.orderBy("state").orderBy("population", descending: true);
爪哇
Python
Python
C++
cities_ref.OrderBy("state").OrderBy("name", Query::Direction::kDescending);
節點.js
去
PHP
PHP
有關安裝和創建 Cloud Firestore 客戶端的更多信息,請參閱Cloud Firestore 客戶端庫。
統一
Query query = citiesRef.OrderBy("State").OrderByDescending("Population");
C#
紅寶石
您可以將where()
過濾器與orderBy()
和limit()
結合使用。在下面的例子中,查詢定義了一個人口閾值,按人口升序排序,只返回前幾個超過閾值的結果:
Web version 9
import { query, where, orderBy, limit } from "firebase/firestore"; const q = query(citiesRef, where("population", ">", 100000), orderBy("population"), limit(2));
Web version 8
citiesRef.where("population", ">", 100000).orderBy("population").limit(2);
迅速
citiesRef .whereField("population", isGreaterThan: 100000) .order(by: "population") .limit(to: 2)
目標-C
[[[citiesRef queryWhereField:@"population" isGreaterThan:@100000] queryOrderedByField:@"population"] queryLimitedTo:2];
Kotlin+KTX
citiesRef.whereGreaterThan("population", 100000).orderBy("population").limit(2)
Java
citiesRef.whereGreaterThan("population", 100000).orderBy("population").limit(2);
Dart
final citiesRef = db.collection("cities"); citiesRef .where("population", isGreaterThan: 100000) .orderBy("population") .limit(2);
爪哇
Python
Python
C++
cities_ref.WhereGreaterThan("population", FieldValue::Integer(100000)) .OrderBy("population") .Limit(2);
節點.js
去
PHP
PHP
有關安裝和創建 Cloud Firestore 客戶端的更多信息,請參閱Cloud Firestore 客戶端庫。
統一
Query query = citiesRef .WhereGreaterThan("Population", 2500000) .OrderBy("Population") .Limit(2);
C#
紅寶石
但是,如果您有一個帶有範圍比較( <
、 <=
、 >
、 >=
)的過濾器,您的第一次排序必須在同一字段上,請參閱下面的orderBy()
限制列表。
限制
請注意orderBy()
子句的以下限制:
-
orderBy()
子句還過濾給定字段的存在。結果集將不包括不包含給定字段的文檔。 如果您包含一個帶有範圍比較(
<
、<=
、>
、>=
)的過濾器,您的第一個排序必須在同一個字段上:有效:同一字段上的範圍過濾器和
orderBy
Web version 9
import { query, where, orderBy } from "firebase/firestore"; const q = query(citiesRef, where("population", ">", 100000), orderBy("population"));
Web version 8
citiesRef.where("population", ">", 100000).orderBy("population");
迅速
注意:此產品不適用於 watchOS 和 App Clip 目標。citiesRef .whereField("population", isGreaterThan: 100000) .order(by: "population")
目標-C
注意:此產品不適用於 watchOS 和 App Clip 目標。[[citiesRef queryWhereField:@"population" isGreaterThan:@100000] queryOrderedByField:@"population"];
Kotlin+KTX
citiesRef.whereGreaterThan("population", 100000).orderBy("population")
Java
citiesRef.whereGreaterThan("population", 100000).orderBy("population");
Dart
final citiesRef = db.collection("cities"); citiesRef.where("population", isGreaterThan: 100000).orderBy("population");
爪哇
Query query = cities.whereGreaterThan("population", 2500000L).orderBy("population");
Python
Python
節點.js
去
PHP
PHP
有關安裝和創建 Cloud Firestore 客戶端的更多信息,請參閱Cloud Firestore 客戶端庫。
統一
Query query = citiesRef .WhereGreaterThan("Population", 2500000) .OrderBy("Population");
C#
紅寶石
無效:不同字段上的範圍過濾器和一階
orderBy
Web version 9
import { query, where, orderBy } from "firebase/firestore"; const q = query(citiesRef, where("population", ">", 100000), orderBy("country"));
Web version 8
citiesRef.where("population", ">", 100000).orderBy("country");
迅速
注意:此產品不適用於 watchOS 和 App Clip 目標。citiesRef .whereField("population", isGreaterThan: 100000) .order(by: "country")
目標-C
注意:此產品不適用於 watchOS 和 App Clip 目標。[[citiesRef queryWhereField:@"population" isGreaterThan:@100000] queryOrderedByField:@"country"];
Kotlin+KTX
citiesRef.whereGreaterThan("population", 100000).orderBy("country")
Java
citiesRef.whereGreaterThan("population", 100000).orderBy("country");
Dart
final citiesRef = db.collection("cities"); citiesRef.where("population", isGreaterThan: 100000).orderBy("country");
爪哇
Python
Python
C++
// BAD EXAMPLE -- will crash the program: cities_ref.WhereGreaterThan("population", FieldValue::Integer(100000)) .OrderBy("country");
節點.js
去
PHP
PHP
有關安裝和創建 Cloud Firestore 客戶端的更多信息,請參閱Cloud Firestore 客戶端庫。
統一
Query query = citiesRef .WhereGreaterThan("Population", 2500000) .OrderBy("Country");
C#
紅寶石
- 您不能按相等 (
=
) 或in
中包含的任何字段對查詢進行排序。