Case insensitive sorting with Firebase orderByChild

Question

I’m using a FirebaseRecyclerAdapter to display a list of strings. My query uses orderByChild. The results sorts with capitalize letters first and looks like this:

Item 1, Item 2, Item 3, aItem, bItem, zItem.

How do I use orderByChild resulting in case insensitive sorting?

score 17 · Accepted Answer · answered Jun 05 '16 at 16:06

17

You don't. Kind of.

If you have data you want to sort by but there also needs to be a user representation of that data, keep two versions

posts
  post_id_0
    display_version: William
    sort_version: william
  post_id_1
    display_version: Henry
    sort_version: henry

Of course you could read in all of the data from Firebase and use .toLower or whatever your platform call is and then sort in code.

answered Jun 05 '16 at 16:06

Jay

32,092
17
52
78

https://stackoverflow.com/questions/64990161/how-to-search-using-lowercase-in-firebaserecycleroptions-in-android-java – MadhanMohan Nov 24 '20 at 17:21
check the above question bro, I too have that question – MadhanMohan Nov 24 '20 at 17:22
is there anyway to do search without case sensitive – MadhanMohan Nov 24 '20 at 17:22

score 0 · Answer 2 · answered Aug 25 '20 at 19:58

0

You can sort your local data source such as List by using sortBy():

firebaseUsers.sortBy { it.user.nickName.toLowerCase(Locale.ROOT) }

answered Aug 25 '20 at 19:58

Sam Chen

5,527
2
29
45

Case insensitive sorting with Firebase orderByChild

2 Answers2

Linked

Related