View executed SQL statement

mfitportal

I was wondering if there's a way in 1.10 to see the executed SQL statement built by Datatables to retrieve the data from the database. I saw this post in the forums about how to do this but there doesn't appear to be a call to file_put_contents() in Query.php nor in MysqlQuery.php anymore.

allan

Add ->debug(true) immediately before the ->process(...) method call for the Editor class on the server-side. Then look at the response JSON in your browser's Network Inspector. It will show a debug parameter that contains the executed SQL.

Allan