Copy an Aggregate and Paste as an Advanced Query

By João Sousa on 4 Jan 2017

I would like to be able to copy an aggregate and paste it as an Advanced Query so i can continue the query development on advance query mode. The view SQL is very helpful but you still have to convert the SQL. 

Justin James5 Jan 2017

This has more or less been declared "done" for the time being, but I'd still like to see this done in a better way:

https://www.outsystems.com/ideas/49/simple-query-to-advanced-convertion

J.Ja

Tim Timperman12 Jul 2017

Agreed. The current "solution" is not sufficient.

The executed SQL is nowhere near what is a valid advanced query. For starters, it features the actual table names instead of entity names. You also need to fill in all parameters or you where clauses will just not be there.