Hi lujeffcoat,
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 lujeffcoat,

I logged in successfully.
I have some questions before I can investigate it.

I saw from your post below that you used wpdatatables constructor and if you take a look at our documentation you can see that wpDataTables Constructor is just a helper:

"Please note that WPDB query constructor is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need. So play around with the resulting query." 

So our suggestion is when you have queries like this, can you please make a VIEW in phpmyadmin or any other database management system and see if filtering is working.

If the VIEW is returning the desired data and filtering is working you can use that query as Add from data source option to create tables.