How to log whole resulting executed SQL through aggregate and advanced SQL?
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.
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