Hello,

Could you show me the SQL Query that was used for this table - and I can advise if maybe some small modification/correction is needed to get the search to work?

-

But you can also check these points to save time if you wish.

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, and search may not work properly if you include:

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

-

So, first you can check for accent graves around the table name, if you have this, remove it...

Then, see if you used CONCAT to create any column.

If so, go into this column setting, and disable it from "global search" in the Filtering tab.

-

-

If none of that helps,

you can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.

 If you need help with that, you can see our video, where we show an example of using View in our plugin.

-

Let me know If that helped, and i can take a look at the Query, as well.

Thank you

Hi Michael,

If you do the "star" inside your SELECT statement, then you won't be able to select a specific Column like :

SELECT * (ALL) , then add a specific Column Name after the "all" part, that is not good practice in the SQL Syntax.

It means you are already calling all Columns once - then you are 'doubling' calling one of the Columns again.

Instead, only call the columns you need once, like :

SELECT ColumnA,
Column B,
ColumnC,
FROM wp_wpdatatable_1

Try to avoid using the ALIAS ( AS) , but rather just call the Column Name as it is from the SQL Database.

I am also a bit confused, the way you are calling this "Year" Column;

Can you check, in the SQL Database, under the wp_wpdatatable_1,  what is the Origin Column name, is it "datum", or is it "Year"?

Please log in your PHPMyAdmin/ or any other DB Management Tool, and double-check, what is the Origin Colum Name, then just call it like that in the Query.

So, let's say if it is just "datum", along with a couple other Columns, then something like :

SELECT Colum 1,
Column2
datum
FROM wp_wpdatatable1

Then, in the Column's Display Name, you can change it to anything you need.

Here is my example. Let's say if I wanted to call this table dummy_employees from my Database and some specific columns.

If i say : SELECT *  - that means SELECT ALL columns;  then if i add another specific Column name, after i already call all of them - then the Plugins SQL Parser will get 'confused' since you already called this column twice, in my example once as 'birthdate' then again as alias AS 'some other Column name'.

In that case, the filtering won't work correctly.

The solution is as proposed above - you can try adding ALIAS / AS to a Column, just don't call the same Column twice - call each of the existing Column once in your Query, such as, on my example :

SELECT firstname,
lastname,
birthdate,
date_hired AS hired,
position
FROM dummy_employees

So, if you can even avoid having the ALIAS/AS, and just call each Column by their Origin Name, then you can edit the Displayed Header names as needed - but the filtering should work.

-

Other than that, you can also disable server-side processing if you need more 'flexibility' in the Query.

Let me know if that helps.

If you still can't solve the issue, we can remote in - we would just need access as Admin and to the Database.

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.

Thank you.

Hi Michael,

You're welcome, I am happy to advise.

It is not a problem at all, you can always ask us any questions about any Plugin function/option, it is very easy to lose some 'detail' since there are a lot of options and workarounds to go through;

 so please don't hesitate to reach out with new tickets whenever any new question comes up.

Thank you.