Pages and numbers ordering issue

[PatrickRQ]

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]

Please could you show the setup of that field? Type more than anything

[opentype]

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]

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]

As it is being stored as text, this would be expected as this is how MySQL orders text.

[PatrickRQ]

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]

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]

Feel free to move it there to avoid messing in forums. Thanks.