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

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

mvp_badge
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.

Thanks Afonso.

mvp_badge
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.