Can I use sql as the query language with DataTables?
Can I use sql as the query language with DataTables?
crcam
Posts: 2Questions: 1Answers: 0
I have successfully used DataTables to display tables. However I would like to generate summaries of tables, using sql features such as select count(distinct field). I am sure that this is possible, as it is supported in WpDataTables, the WordPress interface to DataTables.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
You can't use SQL to query a DataTable (it doesn't implement an SQL interpreter!), but you could query your database and display summary information if you wanted. Or you could use the API to get summary information like in this example.
Allan
Thank you for the quick response. I think DataTables is excellent. Keep up the good work!