View executed SQL statement

View executed SQL statement

mfitportalmfitportal Posts: 20Questions: 7Answers: 0

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.

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Answer ✓

    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

This discussion has been closed.