10
 Followers
54
 Likes

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 (8)

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?

Abraço.



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.
Merged this idea with 'Convert Aggregate To Advance Query' (created on 27 Sep 2018 16:51:08 by Vítor Rosário)

How many of you out there already needed to convert an aggregate to advance query.

In my case when the aggregate starts to grow alittle bit more like more then 7 tables or alot of filter conditions. I just get lost trying to understand the aggregate.

I know, when the test values of the aggregate runs we have the execute SQL as a preview.

NOW why don´t we do an the extra step to allow us to convert the aggregate into an advance query? It will be a good starting point for us to enhance the existing query or make it more readable.


Tell me your thoughts



This comment was:
- originally posted on idea 'Convert Aggregate To Advance Query' (created on 27 Sep 2018 by Vítor Rosário)
- merged to idea 'Transform Aggregate to Advanced Query' on 27 Sep 2018 17:11:12 by Daniel Martins

I think this idea should merged with this one.



This comment was:
- originally posted on idea 'Convert Aggregate To Advance Query' (created on 27 Sep 2018 by Vítor Rosário)
- merged to idea 'Transform Aggregate to Advanced Query' on 27 Sep 2018 17:11:12 by Daniel Martins
views
445
Followers
10