We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3769838
wpDataTables integers sorting like text
Closed

Comments

  • Jim Allen started the conversation

    Columns are not sorting properly. When I sort the "g" column in descending order, 99 appears before 101 as one can see in the attached screen shot.

    Attached files:  G sort.PNG

  •   Miloš replied privately
  • Jim Allen replied

    Miloš,

    The column's data type was set for integer. As a test, I changed it to string, saved it, and then returned it to integer, saved it and, unfortunately, sorting in descending order the highest value is 99, when there are values of 100 and higher.

    Jim

  • Jim Allen replied

    All the other integer columns sort normally. The MySQL original is also integer for all integer fields.

  •   Miloš replied privately
  • Jim Allen replied

    Miloš,

    I have uploaded the zip file to Google Drive, since WeTransfer's page was not working properly and it was taking forever to attach here. Here is the link:

    https://drive.google.com/file/d/1FL6dvuw7S-DN_QtozmHRrJv88PKZij8f/view?usp=sharing

    The wpDataTables query is the most basic: 

    select * from catchers_cs

    That's it, I think.

    Jim


  • Jim Allen replied

    Miloš,

    No luck solving my problem? Would it help if I sent you the original cvs file to see if you can get a different result?

    Perhaps my installation has been the problem.

    Jim

  •   Miloš replied privately