Sort table based on decimal value not working

mpmohi · January 23, 2023, 6:27pm

Hi,

I am not sure how retool's sorting in table working. For integer type of data it seems to work correctly, but when my data is decimal ( 0.34 , 0.44 ...) it fails to sort the table rows when updating

Let me know what's wrong here.
Thanks.

dcartlidge · January 25, 2023, 4:29pm

Without being able to see the data for that custom column I imagine that it's actually a string not a number so the sorting isn't as you expect. Can you check the data type is numeric and not a string?

mpmohi · January 25, 2023, 9:00pm

thanks for reply,

column type was auto. I see that setting it number made it work as expected but shouldn't that be handled with auto type though (!)

victoria · January 25, 2023, 9:17pm

Definitely agreed that Auto should be able to handle sorting decimals. Linked this thread to an internal ticket to address though, a genuine thank you for sharing your experience here!