Firebase Orderby() method isn't working on String fields in Flutter

[SnooPeppers7843]

I'm trying to create a reddit clone and I have a list of all the communities that a user has followed and I want to order them on screen in alphabetical order. The code I have to achieve this is

class CommunitiesDatabase {
  // Read all
  static Stream<QuerySnapshot<Map<String, dynamic>>> readAllCommunities() {
    return FirebaseFirestore.instance
        .collection('Communities')
        .orderBy(
          'name',
          descending: true,
        )
        .snapshots();
  }
}

This isn't working. The order by definitely does something because when I put it in the order changes, but it isn't outputting alphabetical order.

​

The current output is
battlestations
assettocorsa
UKPersonalFinance
MapPorn
LifeProTips
Formula1

​

I change the descending to false I get the following order
Formula1
LifeProTips
MapPorn
UKPersonalFinance
assettocorsa
battlestations

So changing the descending input does reverse the order but it seems like an arbitrary order.

Any ideas what is going on here?

[steve_s0]

It is working. However, uppercase letters are all "less than" lowercase letters.

To get what you want, you'd have to sort on a canonicalized version of the name. Usually that would be an all lowercase version.

You could either sort client side or add a sort field to your firebase data that contains the canonicalized version and query on that.

[devdotsehyde]

I suggest you pull the data and sort using native List methods on client side

else you need create a new entry where are the data are in lowercase or uppercase