Flutter Firestore: :How I can order firestore query by field/value inside map?

Question

I tried:

FirebaseFirestore.instance
        .collection('messages')                  
        .orderBy('sentDate', descending: false)
        .snapshots(),

but it didn't work.

Firebase Firestore collection/path

Frank van Puffelen · Accepted Answer · 2021-11-20 15:17:24Z

5

If you want to order by the sendDate of a specific entry in the map you can using dot notation:

.orderBy('167361790.sentDate', descending: false)

If you want to sort on the sentDate of a dynamically selected map entry, that isn't possible with your current data model, and you'll want to modify your data model to allow the use-case.

For example, if you want to order the messages on the most recent sentDate, you should add a top-level field to the document latestSentDate, update that whenever you write to the map, and then sort on that.

answered Nov 20, 2021 at 15:17

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

Flutter Firestore: :How I can order firestore query by field/value inside map?

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