72
Views
3
Comments
Solved
How to log whole resulting executed SQL through aggregate and advanced SQL ?

How to log whole resulting executed SQL through aggregate and advanced SQL?

2019-06-15 21-39-22
Afonso Carvalho
 
MVP
Solution

Hi Nagesh,

I don't think there's a feature that will do this for you. The "Executed SQL" tab in aggregates and advanced queries will show you the generated SQL, but there's no way to access it programmatically.

Your best bet would be to keep the query on-hand and register its parameters , so you can generate it yourself if necessary, or if you always want to log it, keep a String of the generated SQL and then replace its parameters, so you can log the whole result to the database.

2020-04-20 15-36-48
Nagesh Soradge

Thanks Afonso.

2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi,

Not a direct answer to your question, but in onpremise some more logging is available (for a DBA):
https://success.outsystems.com/Documentation/11/Developing_an_Application/Troubleshooting_Applications/Trace_Executed_Queries_Back_to_Your_OutSystems_Applications

Regards,

Daniel

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.