CODEWITHSUNDEEP
javascriptnode.jsfirebasegoogle-cloud-firestore
Luciano Barreto
Luciano Barreto

Reputation: 76

Get the 10 last documents from firestore

I'm trying to get the last ten documents created on firestore. I tried everything, for example:

firebase.firestore()
    .collection("posts")
    .where("createdAt", "<=", new Date().getTime())
    .limit(10)

or

firebase.firestore()
    .collection("posts")
    .orderBy("createdAt")
    .limit(10)

but instead of returning the last 10, it returned the first 10. Then I tried

firebase.firestore()
    .collection("posts")
    .limit(10)

and it worked fine for the first eleven documents, but when I passed that quantity of documents it started skipping some documents.

Upvotes: 2

Views: 1741

Answers (1)

Doug Stevenson
Doug Stevenson

Reputation: 317402

First, you need to define a sort order for your query. If you want the last 10 documents in that order, you should then reverse the sort order. If you want the last 10 sorted by the field createdAt, then you should define a sort order like this:

firebase.firestore()
    .collection("posts")
    .orderBy("createdAt", "desc")
    .limit(10)

"desc" will reverse the default sort order, making them sort from greatest to lowest.

I suggest reviewing the documentation on ordering and limiting data to learn more.

Upvotes: 3

Related Questions