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 :(

如何实现这一目标? 问候:)

How to achieve this? Regards :)

推荐答案

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如下:

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

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