I have an issue with sorting:asc and sorting_desc in number columns. When I try to order any column with numbers, sorting:asc and sorting_desc dont work fine.
Them don´t order data coprrectly. For example, if I want to order from top to zero any column, the result is:
Can you please check in the Table settings on Wp-Admin, what is that column set for the Data type, is it set as String?
If so - the String columns can only sort by alphabetical logic, they can not sort as arithmetical.
To solve this - Just change the Column Type from String to any Numerical Column, such as integer, or Floatif you need decimal points and then it will start sorting by arithmetical logic.
Hi!
Firstly, sorry for my English level.
I have an issue with sorting:asc and sorting_desc in number columns. When I try to order any column with numbers, sorting:asc and sorting_desc dont work fine.
Them don´t order data coprrectly. For example, if I want to order from top to zero any column, the result is:
99999
9950
9945
98000
The correct order should be:
99999
98000
9950
9945
Attached files: Captura de pantalla 2024-02-19 113348.jpg
Hi Rodrigo,
Apology for the late response time.
Can you please check in the Table settings on Wp-Admin, what is that column set for the Data type, is it set as String?
If so - the String columns can only sort by alphabetical logic, they can not sort as arithmetical.
To solve this - Just change the Column Type from String to any Numerical Column, such as integer, or Floatif you need decimal points and then it will start sorting by arithmetical logic.
Let me know if that solves the issue.
Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables