How to get SQL queries of Dashboard

Dashboard Designer
#1

Hello Helical Insight,

I am using Helical Insight 4.0. I have created a dashboard with multiple reports. I want to see the queries that are being executed at the dashboard for debugging purposes. Is there a way to see this without going to individual reports?

Thanks,
Snow.

#2

Hello Snow,

The SQL queries for the reports on the dashboard can be obtained in the logs.

  1. Go to the Home Page of the application, and change the logger settings from “Error” to “Debug”

image

  1. Refresh the dashboard.

  2. Go to the logs present at location …/hi/hi-repository/System/Logs

You will find the SQL queries that have been generated. It is important that once you have seen the SQLQueries you revert the error settings back to error mode (don’t keep it to debug mode).

Thanks,
Helical Insight