Yes that is the behavior if you have column type string. My suggestion is to set column type on integer or flout. You can add than suffix mm with option Cell content suffix on DISPLAY tab in column settings.
We don't have any security or firewall on our side. We accessing every day to the different servers from our customers from all over the world and we don't have this issue. One of the customers have same issue and he find out that our country Serbia was on block list on the server.
We try again and we are getting same results.(attachment)
Like I explain you in previous post, you have to change that column in database in decimal(16,4), but before that you have to remove sign - and replace with NULL from that column in database and also all numbers in format 4.0-6.5 because it is not proper format for decimal column in database(same thing in our plugin).
Hi
We struggle to get the sorting fixed.
Sizes are not sorted from small to large (or vice versa) for the "thickness" column.
This happens on all tables
See screenshot attached
Regards
Hi Freestocksteel,
Thank you for your purchase.
Yes that is the behavior if you have column type string. My suggestion is to set column type on integer or flout. You can add than suffix mm with option Cell content suffix on DISPLAY tab in column settings.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Freestocksteel,
We don't have any security or firewall on our side. We accessing every day to the different servers from our customers from all over the world and we don't have this issue. One of the customers have same issue and he find out that our country Serbia was on block list on the server.
We try again and we are getting same results.(attachment)
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Dear Milan
Your previous solution worked 100% for us to resolve the sorting issue.
We have applied this on a table (Freestock_Master_Import) which is now sorting perfect.
We now need to apply the same for another table(Freestock_Admin_Import) but are not sure what you have previously done.
If possible could you please again create a sample sql file with the one change?
1.) Item #6 - Thickness_mm - Change from varchar to decimal(16,4)
I will then drop the existing table and rename your newly created table to Freestock_Admin_Import
Your assistance is much appreciated.
Regards
Stephan
Hi Stephan,
Like I explain you in previous post, you have to change that column in database in decimal(16,4), but before that you have to remove sign - and replace with NULL from that column in database and also all numbers in format 4.0-6.5 because it is not proper format for decimal column in database(same thing in our plugin).
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan
Yes I know but I do not understand what you mean with " remove sign - and replace with NULL from that column in database"
Must I drop that specific column(Thickness) and create a new one exactly the same as per screenshot?
Yes we will change the numbers in the incorrect format (4.0-6.5) that is understood.
Should we then import the CSV file again?
Thank you for your advice
Regards
Stephan
Thanks Fixed
Hi Freestocksteel,
You are welcome.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. Thanks!
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables