Hi, Griet De Groote.

Sorry for a late reply, we don't work during the weekends.

-

Can you please open your browser's developer console ( for Chrome and Mozilla the hotkey is F12) ,

keep the network Tab open, then try to edit again,

let us know if you spot any error in red text.

If so, please click into this error, see what is the error code and does it show you a "Preview" of error text.

If you catch the error, please show me some screenshots or a Video.

If it shows any sensitive data, please mark reply as PRIVATE, for safety reasons.

We can also take a remote look for you, if you can provide us with access to this table.

Can you confirm does the issue happen only on front-end,  does the table work OK at the back-end?

Please provide me a temporary WP-admin (administrator) user 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 parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And point us to the table ID. Thanks.

Hello, Griet De Groote.

Our developers additionally advised.

They isolated the issue that causes editing to fail if the columns that have origin Header names as numbers are placed in the Query ( without the ALIAS workaround),

and are going to try and make a permanent fix for this as soon as possible.

-

If you wish, they made this workaround which you can try - this can help them to see if it would work,

and if that works in your case, they need to do further testing to ensure it does not cause any issue for any other plugin functionalities before we implement it into the plugin's core in one of the future updates.

-

It works on our initial testing, so here is what you can do.

Please find this JS file in your plugins folder, either via FTP or through your Hosting File Manager,

in this path :

wp-content/plugins/wpdatatables/assets/js/wpdatatables/wpdatatables.js

Around line 155 find this :

if ($inputElement.data("key").toLowerCase() === 'wdt_id' && isDuplicate) {

Replace it with :

if ($inputElement.data("key").toString().toLowerCase() === 'wdt_id' && isDuplicate) {

and please disable/uncheck this option, in main plugin settings/Custom JS and CSS/

Use minified wpDataTables Javascript.

Let me know if that fixes the issue on your installation.

If you are not able to do this code edit, we can do it for you,

for that we would need  FTP credentials.

If you send that, make sure to mark reply as PRIVATE for safety.

Thank you.

Hello, Griet De Groote.

I am happy to hear that you made progress with those column names, great!

-

In regards to the sorting issues, i am looking at your table #1 , and any column header i click into, it seems to be sorting correctly.

Could you please show us what kind of sorting issues can you see?

If you can send any screenshots or even better a Video, to point it out for us.

Thank you.

Hi,  Griet De Groote.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I see what you mean, thank you for the screenshot and the Query,

you're trying to get a "Sort by, then by another column", in our plugin we have limitations for that use-case.

-

1. Regarding the "first, default" column - Each column has a “Default sorting column” switch.

 If you enable this switch for one of the columns, a selectbox will appear with options – “Ascending” and “Descending”, where you can choose the sorting direction . More about sorting with our plugin features you can read in our docs here - https://wpdatatables.com/documentation/table-features/sorting/

2. - The only way you can sort the table by multiple columns with plugin's built-in functionality would be, on the front-end, if you hold down SHIFT and click on the header of 2(or more) columns. ( in your case column B, then C)

Basically, this means that, after the table loads, a page visitor has to do this, 

click on the C column whilst holding SHIFT(added the clicked column as a secondary, tertiary etc ordering column)."

-

But, for this use-case, since you need this to be "already done before the page loads", 

there is a custom workaround, with an SQL Query;

we are not suggesting to use ORDER BY at all in queries, because wpDataTables plugin is adding it dynamically based on what is set to be default sorting column.

but if you disable the Sorting option for wpDataTable and create wpDataTable from SQL query e.g:

SELECT * FROM `my_table` ORDER BY ColumnB ASC, ColumnC ASC

It will create and show wpDataTable with multi-column sorting, but you will not be able to use Sorting anymore for this table from within our Plugin.

Let us know if that helps.