Creating reports and dashboards | Stimulsoft community forum

Posted: **Thu Jan 23, 2014 12:12 pm**

How can view last executed query? I mean, I would like to see somewhere in the report or in a log file the sql used for the report.
Thank you!

Nicola

Posted: **Fri Jan 24, 2014 12:55 pm**

Hello, Nicola.

To save last SQL query you could make next changes in the handler.php file.

Find

Code: Select all

$query = base64_decode($query);

line in the sti_client_event_handler() function.

Add next line after this one:

Code: Select all

file_put_contents("last_query.txt", $query);

The last_query.txt will content the last SQL query.

Thank you.

Creating reports and dashboards | Stimulsoft community forum

view last executed query

view last executed query

Re: view last executed query