Quote:
Originally Posted by ownedbycats
I have a composite column that usually shows a number. However, for a subset of books it shows a value like '60/70.'
If I set the column to sort by number, it fails to sort entirely. I have to do it by text, but this results in weird sorting (e.g. 10, then 100, then 11). Is this intended?
 |
The failure happens because the column doesn't contain a number.
Setting the sort to "text" will result in the behavior you see. It sorts by character left to right. The tweak "Recognize numbers inside text when sorting (ID: numeric_collation)" might change that, but it will change it for all text sorts.