Is it possible to see the SQL generated by an Aggregate
Question

Hi,

Can we see the sql generated for the aggregate? If yes, please mention the place where to check the sql query

Thanks,

Pavani

mvp_badge
MVP
Solution

Hi Pavani,

You can't see the exact SQL being generated unless you use some kind of database monitoring tool, but if you have opened an Aggregate, there's the "Executed SQL" Property that shows the SQL in a form that's almost equal to the actual SQL:

You can double click to open the full SQL:

Make sure you have specified all Test Values, or the SQL might not be exactly what you'd expect (because Identifiers must be tested against NULL instead of compared with an equal sign).


Thanks Kilian for clarifying the doubt.

mvp_badge
MVP

You're welcome :). Happy coding!

With version 11, you have to click any tab of the aggregate once you double-click (open)  the aggregate to see the property. Otherwise, you cannot see anything in the property area.

mvp_badge
MVP

Hi Hongnan,

Thanks for the observation, I'll pass it along to OutSystems.

Kilian Hekhuis wrote:

Hi Hongnan,

Thanks for the observation, I'll pass it along to OutSystems.

Still happening until now. It's kinda bug. Also, you can convert your aggregate to SQL by doing that trick. :)


In reactive I cannot find the SQL at all... Any ideas on where to look?

Hi Liesbeth,

In reactive with aggregate and Advance SQL we can see the executed SQL as you can see in the below screenshots.

With Aggregate - It will show you executed SQL after you test your query

With Advance SQL - Again test it to see the result

Thanks


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