Firestore: How to use order by field of object of array

Question

I have a database like this.

How can I order by the timestamp field in the array?

.orderBy("received[0].timestamp", "desc")

psygo · Accepted Answer · 2022-09-27 14:09:17Z

4

You cannot directly. But what you can do is create a new field on your document called firstTimestamp or something similar, and then replicate the timestamp from the first element of the array into that field. You can do that in a Cloud Function or in your frontend/backend code. That way you can sort or filter by that field.

edited Sep 27, 2022 at 14:09

psygo

7,8638 gold badges63 silver badges112 bronze badges

answered Sep 27, 2018 at 11:55

Ricardo Smania

3,1692 gold badges28 silver badges36 bronze badges

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

2 Comments

user10412277 Over a year ago

Thank you so much.

Andrey Solera Over a year ago

I didn't understand the answer, can you elaborate with an example?

Collectives™ on Stack Overflow

Firestore: How to use order by field of object of array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related