search

giowck / symphytum

Symphytum Personal Database Software
https://git.io/fxdRt
Other
415 stars 64 forks source link

Number sorting in table view is not working as expected #143

Open piratenpanda opened 4 years ago

piratenpanda commented 4 years ago

In our database inventary numbers are, historically given, 1,2,3 etc. When sorting this field in table view it gets sorted as, e.g., 1,129,2,3,4,5,6,7,8 etc. Could the sort algorithm be improved so that leading zeros are not necessary to sort correctly?

Deanomac commented 4 years ago

You have to change the column data from "text" to "integer".

On Wed, Apr 8, 2020, 4:48 PM piratenpanda notifications@github.com wrote:

In our database inventary numbers are, historically given, 1,2,3 etc. When sorting this field in table view it gets sorted as, e.g., 1,129,2,3,4,5,6,7,8 etc. Could the sort algorithm be improved so that leading zeros are not necessary to sort correctly?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/giowck/symphytum/issues/143, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF6GJEFZUUHTDEX7742UQK3RLTPLRANCNFSM4MEHFJ6A .

piratenpanda commented 4 years ago

Ok i should have mentioned that there are also entries with K1, or W1,W2 that's why the decision was made to use text instead of integer. So it's impossible?