Use numeric ordering on ReorderElementChildren

Erwan Rouchet
2025-12-03T13:36:17Z

https://redmine.teklia.com/issues/12458

ReorderElementChildren should order numbers found within names by their value instead of their individual characters. For example, page 2, then page 10, then page 000011. The default ordering would sort these in reverse.

A custom collation named teklia_en_numeric needs to be created to sort using English rules and with numeric ordering enabled; this is the en-u-kn locale provided by icu. This collation should then be used to sort element names within the raw SQL used in Element.reorder_children. This collation must not be applied on the whole column or used in other places.