How can we get the  exact SQL Query of a report defination?

Hi,

If you want to check the exact query of RD.

- Run the RD. Open Clipboard.

- In Standard thread, click on pyReportContentPage(Code-Pega-List)

Hope this answers your query.

Best Regards,
Mounika

Hi,

There is another way, you can enable the SQL query option (DB Query checkbox in the tracer settings). Run the report and capture the tracer, analyze the tracer captured for the DB query captured for the RD.

Regards,

Basavaraj

Doing DB trace on running report defnition is also another option. In this you can find out the query execution time, bind values as well.