Transform Aggregate to Advanced Query

Aggregates & Queries
On our radar

We all know that the Aggregate is not usable in some certain situations, for example when you want to use some extensions or when you have a DB fields encryption and so on.

I'd like to have an option to transform an aggregate into an advanced query on my code, so I won't waste my time creating lots of joins and filters that I've already created on the aggregate.

This would be really helpful and given that you generate the SQL code it seems pretty doable.

Best regards,

João Carreiro

Created on 16 Nov 2017
Comments (5)

You can of course take the "Executed SQL" property and start from there, but it would indeed be useful to be able to convert it to a properly formatted SQL node.

This is a very good Idea 

Merged this idea with 'Converter aggregate para advanced query' (created on 2018-01-18 13:17:34 by Agno Silveira)

Bom dia,

Seria de grande ajuda converter aggregate para advanced query.

Já existe algo parecido?


Merged from 'Converter aggregate para advanced query' (idea created on 2018-01-18 13:17:34 by Agno Silveira), on 2018-01-19 12:32:14 by leonardo.fernandes
this idea would help a lot in reducing system maintenance time.