Hi, Jason 

Thanks for reaching out to us

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 me to this table ID, please. Thanks

Hi, Jason and Klemen.

My apologies for the late response.

We had a New Years break and are back,   will do our best to be quick with our responses going forward.

I wish you a Happy New Year, and all the best in 2023.

-

Now, to explain what happened.

We have responded as private message since i did some screenshots from Jason's table, i was not sure if that should be publically shared.

My senior colleagues from our 2nd level Team made an example as a new table on Jason's site,

and they also provided an explanation as to what was wrong with the original table configuration, 

i thought it was clear since there was no response from Jason since then, that was in November, but i can see that i was wrong.

The ticket got automatically closed, because my last response was in November, 

our ticketing system closes tickets after 7 days of no replies,  but if anyone replies, the ticket comes up to our attention, we can keep writing on it.

-

2. Regarding filtering that was not working for the foreign key for Jason's case:

The logic for filtering with Foreign key Columns will always be as "Exact Filtering",

so we always have to input the full value - it will not work for "partial matches".

But we will double-check these new details that you mentioned, Jason,  i am reaching out to our 2nd level Team again and we will advise you on it.

-

@Klemen  ,  if i am not mistaken, you have a ticket opened already for this case, this one? https://tmsplugins.ticksy.com/ticket/3188761

If that's correct, you said you were not able to reproduce the issue anymore, but i can see that the issue came back?

Can you please send me WP-Admin access on the ticket, so that we can check the back-end of the table in question?

If you send us any credentials, please mark the reply as PRIVATE on your ticket, so that only we can see it.

And please point out to both Table ID's,   

what is the Table ID that is working without issues;

and what is the Table ID with the issue as well.

Then we can check everything for you.

It will be good if you also grant us access to your database, so that we can check the columns and setup there.

It can be either link with credentials to PhPMyAdmin or cPanel access.

Thank you

Hi guys.

 Since yesterday was 7 days from my response,

 in order to prevent this ticket from closing automatically again, I'm posting another response here to see if you still need assistance with this.

If this comment goes without a response for another 7 days, please note that the ticket will close again, and we will assume your issues have been resolved.

Thank you

Hi, Klemen

I have responded to your individual ticket, but I will also provide this explanation here.

Our SQL feature runs everything through our Parser,

and it has certain limitations.

-

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

In order to prevent these filtering/search issues, 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″.

-

But, in regards to editing,

When you are using JOINS with more tables please note that in wpdatatables just one table can be editable at the moment and that is the reason why you can't edit fields in table that you made from two tables.

-

We are sorry for the inconvenience but those are the limitations that our SQL parser has currently.

Let us know if that makes sense and if you have any questions. Thank you