Flutter - Can't get collection from firestore

Question

    _getLatestCompletedWorkout() async {
  try {
    QuerySnapshot workouts;
    workouts = await FirebaseFirestore.instance
        .collection('users')
        .doc(FirebaseAuth.instance.currentUser!.uid)
        .collection('workouts')
        .get();
    for (var workout in workouts.docs) {
      print('WORKOUT = ');
      print(workout);
    }
.....

What I really need is to get the last document saved; but before that I am just trying to fetch the "workouts" collection; the workouts.docs list always has 0 items. There are 2 items in the DB. What is wrong with this code? Also how to get the last saved item?

For the last question, see https://stackoverflow.com/questions/54178951/get-last-created-document-in-a-firebase-firestore-collection and more from https://www.google.com/search?q=how+to+get+the+last+saved+document+from+firestore — Frank van Puffelen, Dec 11 '21 at 15:55

Divyani Yadav · Accepted Answer · 2021-12-13T09:25:43.880

0

As mentioned by Frank :

You can refer Alex answer here :

The simplest way to achieve this is to add a date property to each object in your collection, then simply query it according to this new property descending and call limit(1) function.

This is the required query:
this.historyRef = afs.collection<History>('history', ref => ref.orderBy('date', 'desc').limit(1));
this.history = this.historyRef.snapshotChanges().map(actions => {
    return actions.map(a => {
        const data = a.payload.doc.data() as Hisotory;
        const docId = a.payload.doc.id;
        return { docId, ...data };
    });
});

edited Dec 13 '21 at 09:25

answered Dec 13 '21 at 08:11

Divyani Yadav

1,030
4
9

Yes Frank's comment helped. I save the data with date and retrieve in the descending order and take the first element. – who-aditya-nawandar Dec 21 '21 at 10:19

score 0 · Answer 2 · answered Jun 21 '22 at 13:49

This has been found since cloud_firestore updates that prevent app that not regiter in App Check to take updates seriously "but it store it with lighter id color" which Protect your Cloud Firestore resources from abuse, such as billing fraud or phishing

Kindly check and ensure your app is registered inside App Check in Firebase console

Flutter - Can't get collection from firestore

2 Answers2