10.11.2023
10:27
Hello,
Do you know how can i find what query is exactly executed when i'm using raports in WEBCON.
What SQL SELECT is inside, I knew that i can find it some where in the console(debug mode) F12, but I can't find it right now.
Or there is some database table with this ?
10.11.2023
11:00
Turn on diagnostic (Option in your user menu on top right side of screen).
Open raport, and then you can find SQL.
13.11.2023
09:05
MVP
Hi,
Turning on the debug mode as Rafał wrote, the SQL query generating the report data can be found in the section as in the screenshot I am attaching.
But if the query takes a long time and returns timout, then you can use SQL Studio and,
for example, using Activity Monitor, 'catch' the query during execution, e.g. in the 'Active expensive Queries' section.
Regards
