How Order data by two field in firebase

Question

How I can order data doc by two field, My app have a stream builder and I want order the data by the time that wrote and if the todo important so there is two field in docs one for time and there is boolen value i want the data order by the time and if the data important that is mean the boolen true to be in the top of the list of stream and when i add data will show ender it. this the code I used for strem

final FirebaseFirestore firestore;
  DataBase({this.firestore});
  Stream streamTodos({String uid}) {
    try {
      return firestore
          .collection("homeNeeds")
          .doc(uid)
          .collection('homeNeeds')
          .orderBy('time', descending: true)
          .snapshots();

    
    } catch (e) {
      return e;
    }
  }

// i tried to put tow orderBy('time', descending: true).orderBy('pin', descending: true) and it doesn't work the snap shot return empty

Jaime Ortiz · Accepted Answer · 2021-05-31 00:43:14Z

0

it appears that is not as simple as saying you can or you can not, it depends on your specific case, but most likely you'll have to do it client-side.

There is another question like this one here:

answered May 31, 2021 at 0:43

Jaime Ortiz

1,34914 silver badges14 bronze badges

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

Comments

kietle · Accepted Answer · 2021-05-31 00:59:21Z

0

You can use multi_sort: ^3.0.0 in this case.

https://pub.dev/packages/multi_sort

answered May 31, 2021 at 0:59

kietle

1786 bronze badges

Comments

asm · Accepted Answer · 2021-05-31 23:29:38Z

0

I solved this problem by adding Indexes in cloud firestore and that option allow you to use tow orderby in the same code

answered May 31, 2021 at 23:29

asm

1

Collectives™ on Stack Overflow

How Order data by two field in firebase

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related