PatrickRQ Posted October 5, 2022 Posted October 5, 2022 (edited) Hello, Pages has ancient issue of records ordering when number is involved: When you configure a text field containing number and use it to order records, the order will go wrong following way: 1.1.1.0 1.1.1.1 1.1.1.10 1.1.1.11 1.1.1.12 1.1.1.2 1.1.1.3 valid order should be 1.1.1.0 1.1.1.1 1.1.1.2 1.1.1.3 1.1.1.10 1.1.1.11 1.1.1.12 Edited October 5, 2022 by PatrickRQ
Marc Posted October 5, 2022 Posted October 5, 2022 Please could you show the setup of that field? Type more than anything
opentype Posted October 5, 2022 Posted October 5, 2022 1 hour ago, PatrickRQ said: valid order should be What is valid would depend on context. The only real solution would be to offer a selection for the various ordering types.Â
PatrickRQ Posted October 5, 2022 Author Posted October 5, 2022 (edited) 7 hours ago, opentype said: What is valid would depend on context. The only real solution would be to offer a selection for the various ordering types. Valid in aspect of numbering order. 8 hours ago, Marc Stridgen said: Please could you show the setup of that field? Type more than anything Edited October 5, 2022 by PatrickRQ
Jim M Posted October 5, 2022 Posted October 5, 2022 As it is being stored as text, this would be expected as this is how MySQL orders text.
PatrickRQ Posted October 5, 2022 Author Posted October 5, 2022 So there is no option to properly order version number for e.g. software. As @opentypesuggested, there would be a need of option to allow to control ordering type text/number for this kind of fields, as regular number field won't allow non-number input 🙂
Jim M Posted October 5, 2022 Posted October 5, 2022 Precisely, I'm afraid, what is happening is currently intended so you would need to create a topic in our Feature Suggestion forum for any new ordering schemes.
PatrickRQ Posted October 5, 2022 Author Posted October 5, 2022 Feel free to move it there to avoid messing in forums. Thanks.
Recommended Posts