Firebase Firestore - 或查询 [英] Firebase Firestore - OR query

问题描述

如何通过一个字段的多个值来获取数据?例如，我有包含帖子的数据库，我想查询 blogId 为 1 或 2 的所有帖子，按时间戳排序.

How to get data by multiple values of one field? For example, I have database with posts and I want to query for all posts where blogId is 1 or 2, sorting by timestamp.

collection("posts").whereEqualTo("blogId", "1")
.whereEqualTo("blogId", 2).orderBy("timestamp", Query.Direction.DESCENDING).limit(50)

上面的代码不起作用:(

Code above is not working :(

如何实现?问候:)

推荐答案

Firestore 现在为此支持IN"查询.

查询将如下所示:

database.collection("collectionName").where("fieldName", "in", ["fieldValue1", "fieldValue2"]);

您最多可以有 10 个值 (fieldValueX) 来检查IN".

You can have up to 10 values (fieldValueX) to check "IN" of.

OP 所需的代码如下:

The code OP desired would be as follows:

database.collection("posts").where("blogId", "in", ["1", "2"]); 

这篇关于Firebase Firestore - 或查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！