android - How to sort Firebase Keys in ascending order? -
i have list of products in firebase database. sku looks c08p10
. problem hundred product shown after tenth product.
please refer screenshot jumbled product order.
i can understand products arranging alphabetically. how can display products in below order
c08p10 c08p11 c08p12
note
i can populate data in list view or recycler view. products arranged in firebase db order. if try reverse order. gives below structure.
c08p118 c08p117 c08p116
firebase keys strings. , when order string data, ordered lexicographically.
so numbers, normal order:
- 1
- 9
- 10
- 11
but strings, normal order:
- "1"
- "11"
- "19"
- "9"
there no operator in firebase (nor in other databases) change behavior. instead, have modify data behavior want. so: store values in order need them when sorted lexicographically. numbers can accomplish padding them zeroes:
- "001"
- "009"
- "011"
- "019"
or in case c09p010
, etc.
Comments
Post a Comment