Hello

First of all, great plugin ! The various features are time saving and much easier to set up than your own hand coded instance of datatables, so thank you.

However i've encountered an issue which is very troubling

I have two custom post type with different custom fields and taxonomies and a very high number of entries (thousands or 10s of thousands). In theory, your plugin should allow me to access this data through a wp query by using server side processing.

It works fine when I only use one or two columns, but as soon as I add some, the table preview stops working and i get an error message "db disappeared" and it returns an empty query!

My main issue is that you cannot edit the SQL query after creating the table, so if it doesn't work right off the bat, i can't create a "lite" query that I would then expand one field at a time.

The problem is, my datatable works fine it if i create my own hand coded DT, so the server can take the load, but the ajax call to the query preview in your plugin is returning an error even though i know it should work. 

any idea how to work around this?

thanks for the quick answer 

it was an issue with both JOIN and CONCAT functions, but apparently necessary when querying some Wordpress content in this case 

the work around I found was by using a php array instead, using Wordpress functions to directly return values 

it’s now working with over 50 000 entries !