Hi, Sergey 

Thanks for reaching out to us

I am not sure if i understand the issue completely - Can you please elaborate in a bit more details.

There are a lot of factors to consider, such as what is the table type,

what are the values, i presume they are strings?

The best will be if you could record your screen to show me how all this looks when the issue happens, and i will be able to assist?

Hi, Sergey

Firstly my sincerest apologies for all the waiting time.

Thank you very much for the screenshots ( with the additional drawings, i liked this detail );

I have a couple of ideas why this is not working, and i am confident i can help you resolve it.

Could you send me the SQL Query which you used for table creation, maybe I can spot if it needs a small correction?

-

In some situations, using certain functions within SQL, the wpDataTables server has problems with parsing the query and building new queries dynamically (rarely happens, but does sometimes).

Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types

SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.

Some of them are disabled for security reasons.

Filtering, sorting, calculation functions and search may not work properly if you include:

Accent graves ( ` ) around the table name JOIN functions UNION functions CONCAT functions sub-queries -

• Please do not use “LIMIT” in the SELECT statement. wpDataTables adds it automatically and it will be overridden.
• Please do not use “ORDER BY” in the SELECT statement. wpDataTables has its own sorting engine so it makes no sense to use MySQL’s sorting, since it will be overridden. Also, server-side processing feature adds this part of statement automatically when users trigger the sorting on the front-end, and having it in initial statement may cause the table to crash.

-

To avoid this, can you please prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.

- If you need help creating a View and use it with our plugin, here is our video with an example.

-

Let me know if that helped. Thank you