Generate SQL Query From Report

SumitBanerjee92
Tera Contributor

Hi All,

 

I have a requirement to generate the SQL Query of a report , the query should contain everything starting from filter conditions , the results and all available fields. I tried checking the SQL Debug functionality , but I am not understanding which SQL query is the exact for that report as a lot of queries are getting generated. Any assistance on this is highly appreciated.

 

Thanks

Sumit

1 REPLY 1

Maik Skoddow
Tera Patron
Tera Patron

Sorry, never heard such a strange question before. You already figured out there are many SQL queries in the background und therefore you will not get everything in one. Please explain what you would like to do with such a query as we don't have access to the database.