I am trying to:
Sort table by numeric by clicking on a table column header.
Currently I'm able to click my sort dropdown for "Property Size" field and "Descending" and that sorts correctly (highest numbers on top (the highest being 2300000). But if I click the Property Size table column header, it sorts as a string (eg highest being "9996" and "99875" is shown below that, etc).
Link to a page where the issue can be seen: hidden link
I expected to see:
(see above)
Instead, I got:
(above)
Sorting by "Property Size, Desc" in dropdown (correct result): hidden link
Sorting by "Property Size (desc)" in table column header: hidden link
Just a note that when it works correctly (when you click the sort dropdown), the url is: hidden link
And when you click the table header you get this: hidden link
The property size field is a custom field (just a regular wordpress custom field). When you say is it a number field are you asking if the contents are numbers? If so, then yes it is a square footage number basically.
When I setup the sort dropdown, I selected "Numeric" as well which worked (remember in my previous note on how the dropdown works but clicking the table column headers doesn't). Anyway does that answer your question?
However they dont seem to have admin priviledges. Could you checked on them and let me know or update them to admin ?
Also did you disable the table header sorting because i'm not seeing the table header sorting. The problem could be that the table header is sorting the field as a string and in a case like this, it can sort incorrectly.
