I'm trying to create an ordered list of media, but Community isn't ordering beyond the initial digit. It works fine up to #9, but then it fails. Thoughts?
I'm trying to create an ordered list of media, but Community isn't ordering beyond the initial digit. It works fine up to #9, but then it fails. Thoughts?
Interesting question. The sorting for these queries (and most queries) happens directly on the database side. I'm logging an issue to review their ordering clauses to see how feasible this could be. For now, I'd recommend prepending a 0 to the single-digit-numbered items. So, "01. Introduction to Effectuation".
Sorting is not meant to differentiate a string from a number, it will treat the leading character as the sort field and apply sorting logic based on it alone.