Hi jrdios,
Thank you for your purchase.

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Also point me to the table ID so I can take a look.

Best regards.

Hi jrdios,

Unfortunately I can not see any of the data in the table ( attachment) 

Best regards.

Hi jrdios,

Could you please confirm that this account is administrator level account. This is necessary for me to be able to see plugin and solve the issue.

Also can you please tell me which column does have the sorting issue.

Best regards.

Hi jrdios,

Can you just point me to the table ID and the columns that have a sorting issue so I can take a look.

Best regards.

Hi jrdios,

Can you please try to make a VIEW in phpmyadmin or any other database management system and see if the query will return the right results. If the result is ok you can use that query as an input ( SELECT * FROM VIEW ) when you are creating tables with Add from data source option.

Best regards.

HI jrdios,

Probably our plugin get confused when using join and some other functions and because of that the sort function is not working.

Can you please tell me if you remove the last line from your query is the sorting working correctly.

Best regards.

HI jrdios,

Can you please send me the screenshot of the table in the database so I can see the configuration and column types that are set for the table where sorting is not working.

Best regards.

HI jrdios,

Ok , thank you for explanation.

So the issue is with the foreign key feature.

If you take a look at our documentation about foreign keys you will notice that it is only possible to have the relation if the column is Integer and then later change to string when you define the relation to other table.

Best regards.

Hi jrdios,

Can you please check the wpdatatables support 2.

The issue with the foreign keys can be that when you first create a table the values must be Integer ( with the numbers that can be related to some other table) Then you change the column type to string and make a relation.

Let me know if you have any more questions.

Best regards.