Does anybody know how I enable the "Executed SQL" property for aggregates?

Looking through the forums, I found this post:

https://www.outsystems.com/ideas/3047/access-executed-sql-from-queries-aggregates

And I realised I don't have this option, which is exactly what I'm after.

Thanks.

Solution

Hi 

The module must be published.
After that, just open the aggregate, wait for it to be executed, and if in the properties panel nothing appears, click in the name of the aggregate, at the top of the screen:


It should work.

Cheers.

Solution

Hi Kieran Morten,

This option is available in version 10, not found the same in OS 11. Hope you are using version 11.

Found the same from  Eduardo Jauch's reply

Regards,

Anjitha Mohan



Anjitha,

I have this option both on version 10 and 11.

Cheers.

Eduardo Jauch wrote:

Anjitha,

I have this option both on version 10 and 11.

Cheers.

Hi Eduardo Jauch,

For me, it is not visible in the property window. But I can view it in the aggregate.

Version 11


Version 10

I have it in version 11 as well. Probably, like Eduardo said, the module isn't published.

Worked - thank you! I was just looking for it in the wrong place.