Firestore end before documents not working properly

Question

I am using the below query to get documents before given documents snapshot. when I use descending: false I get initial 5 documents but I want immediate 5 documents before the given documents. When I use descending: true I get an empty list. Please help me. What I am doing wrong here.

Stream<QuerySnapshot> getConversationBefore(String currentUserID,String clientID,DocumentSnapshot documentSnapshot)
      {
           return Firestore.instance
            .collection(FIREBASE_COLLECTION_MESSAGES)
            .document(currentUserID)
            .collection(clientID)
            .orderBy(TIMESTAMP_FIELD, descending: false)
            .endBeforeDocument(documentSnapshot)
            .limit(5)
            .snapshots();
      }

MKougiouris · Answer 1 · 2020-06-26T09:05:47.133

1

EDIT: Also make sure you have initialized an index on the field you are trying to order by, take a look here!

return Firestore.instance
            .collection(FIREBASE_COLLECTION_MESSAGES)
            .document(currentUserID)
            .collection(clientID)
            .orderBy('TIMESTAMP_FIELD', descending: true)
            .endBeforeDocument(documentSnapshot)
            .limit(5)
            .snapshots();

edited Jun 26 '20 at 09:05

answered Jun 26 '20 at 08:46

MKougiouris

2,821
1
16
19

i made an edit, i am not sure what you mean "not accepting desc argument", unless i have missunderstood your stack, and its not firebase... otherwise the snippet is from the examples! – MKougiouris Jun 26 '20 at 08:54
I am using firestore flutter plugin where order by is accepting a field and optional boolean value not a string – Mofidul Islam Jun 26 '20 at 09:03
Take a look here, if it helps tell me to change my answer https://stackoverflow.com/questions/51434167/firestore-query-orderby-not-working – MKougiouris Jun 26 '20 at 09:05
I will try this – Mofidul Islam Jun 26 '20 at 09:26

Firestore end before documents not working properly

1 Answers1