Sort by title doesn't handle numbers correctly

051119 · Dec 12, 2023

When sorting by "Title" it appears to be struggling to sort by number correctly, with a title commencing with "10" appearing between "1" and "2."

Is this likely to be an issue with the fact that the field format is text based and thus it only considers the first character?

mattrogowski · Dec 12, 2023

Just a standard issue when sorting strings, it doesn't interpret 10 as a combined numerical value to be sorted specifically and separately from other characters, as it would have to know all the other values contain numbers that have to have specific sorting applied to them.

051119 · Dec 12, 2023

mattrogowski said:
Just a standard issue when sorting strings, it doesn't interpret 10 as a combined numerical value to be sorted specifically and separately from other characters, as it would have to know all the other values contain numbers that have to have specific sorting applied to them.

Thanks for the reply, can you think of a better way to help me sort them? I'm guessing l might have to just sort by Submission date rather than reorder? I dont suppose theres any addons that may support Display order?

Sort by title doesn't handle numbers correctly

051119

Active member

Attachments

mattrogowski

Well-known member

051119

Active member

We value your privacy