firestore: array empty when i try to get data by date

Question

This is my first time using Firestore. I am not able to get the data from firestore when I add filter by date. I would like to retrieve firestore data save the day before (yesterday). i trying many internet's examples.

i try this:

const query = this.fb.collection('your_collection');
query(`your_directory`,
  ref =>  ref.orderBy('reportedAt').startAt(new Date(2020, 7, 20, 0, 0, 0)));

and this

const query = this.fb.collection('your_collection');
query(`your_directory`,
  ref =>  ref.where('reportedAt','>=', new Date(2020, 7, 20, 0, 0, 0)));

but every time I use one of these methods, I do not find the expected results. he return an empty array.

Could someone explain to me how to solve my problem?

EDIT: response example. Array this data I would like to retrieve a data array whose reportedAt dates from the last day. this is reportedAt on firebase UI

thanks

Please edit the question to show a specific example of a document that should be matched by your query. There's nothing we can do without seeing that your query matches your data in every way. — Doug Stevenson
– Doug Stevenson, Commented Jul 21, 2020 at 0:46
What do you mean you get back an empty array? In the screenshot you are showing as an array that at least has that element — Adrian Pascu
– Adrian Pascu, Commented Jul 21, 2020 at 11:15
What if you subtract one day off the Date you pass to the query? Does it find anything? — Doug Stevenson
– Doug Stevenson, Commented Jul 21, 2020 at 15:04
for the example table, i modified my query to show you what it's content should content. sorry I don't usually post on stackoverflow — willkoua
– willkoua, Commented Jul 21, 2020 at 15:28

willkoua · Accepted Answer · 2020-07-21 16:29:44Z

1

finally my request to work and I still do not understand...

this query don't work

const query = this.fb.collection('your_collection');
query(`your_directory`,
ref =>  ref.orderBy('reportedAt').startAt(new Date(2020, 7, 20, 0, 0, 0)));

but this query work

const query = this.fb.collection('your_collection');
query(`your_directory`,
ref =>  ref.orderBy('reportedAt').startAt(new Date("2020-07-20")));

the difference is in the way of instantiating the Date object. But as I told you I do not understand this behavior.

edited Jul 21, 2020 at 16:29

answered Jul 21, 2020 at 15:41

willkoua

1151 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

firestore: array empty when i try to get data by date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related