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, 20222 yr by PatrickRQ

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

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. 

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, 20222 yr by PatrickRQ

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

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 🙂

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.

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