FireStore 日期查询未按预期工作 [英] FireStore date query not working as expected
问题描述
我有一个包含日期对象的文档.
I have doc which has a date object.
用于初始化 Firestore 的代码:
Code to init Firestore:
FirebaseFirestore fireStore = FirebaseFirestore.getInstance();
FirebaseFirestoreSettings settings = new FirebaseFirestoreSettings.Builder()
.setTimestampsInSnapshotsEnabled(true)
.build();
fireStore.setFirestoreSettings(settings);
firestore = fireStore;
查询代码:
FirebaseFirestore db = FireStoreUtils.getInstance();
Query query= db.collection(viewType.collectionName());
query.whereLessThan("endDate", new Date());
return query.orderBy(viewType.sortProperty()).limit(PAGE_SIZE);
我总是得到所有记录,看起来 where 子句没有得到应用.在 Firebase 控制台上,我看到 endDate
存储为时间戳.
I am always getting all the records and looks like the where clause is not getting applied. On Firebase console I see that the endDate
is stored as timestamp.
来自 Firebase 控制台的文档:
Doc from Firebase console:
createdDate: null (null)
description: "desc" (string)
endDate: February 3, 2019 at 11:18:58 PM UTC-8 (timestamp)
id: "-7475596197450085332" (string)
title: "title"
推荐答案
Cloud Firestore 查询是不可变的,这意味着您无法更改现有查询的属性.如果您通过调用 whereLessThan()
方法更改该值,它将成为一个新查询.所以要解决这个问题,请将所有方法调用链接起来,并将它们存储在一个新的 Query
对象中,如下所示:
Cloud Firestore queries are immutable, which means that you cannot change the properties of an existing query. If you change the value by calling whereLessThan()
method, it becomes a new query. So to solve this, please chain all method calls and store them in a new Query
object like this:
Query query = db.collection(viewType.collectionName())
.whereLessThan("endDate", new Date());
.orderBy(viewType.sortProperty()).limit(PAGE_SIZE);
return query;
这篇关于FireStore 日期查询未按预期工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!