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.

enter image description here

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

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -