Server side processing - row details - sql query

jpeter82

Hi Allan,

First of all, I really like your project, IMHO this is the most useful plugin for Jquery!

I'm trying to put together a table based on your Server side processing - row details example. I want to add a WHERE clause to the Mysql query (filtrering on server side). I'm editing the ids-objects.php (and looking into ssp.class.php). After filling in the necessary parameters it works fine (without filtering). I can see you are using the 'simple' function to actually make the sql query. How can you pass the WHERE, ORDER and LIMIT clauses? Could you please give me an example?

Thanks,
Peter

jpeter82

I have found a new ssp class with examples, might be interesting for others:

http://emranulhadi.wordpress.com/2014/06/05/join-and-extra-condition-support-at-datatables-library-ssp-class/

It handles extra WHERE and also JOIN queries.