21
 Followers
82
 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 (14)

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

In an Action, let us convert a data aggregate to an Advanced SQL. In this case below, I need a where clause that is a NOT IN (select subquery) but can't do that with an aggregate, so I need an Advanced SQL Statement that looks almost identical, but allows me more control over the WHERE clause. 


If I choose Convert to Advanced SQL, then Service Studio should convert it to a nice, human readable equivalent of the definition with the same return types, etc.





This comment was:
- originally posted on idea 'Right-click on Aggregate > Convert to Advanced SQL' (created on 19 Dec 2018 by PJ M)
- merged to idea 'Transform Aggregate to Advanced Query' on 20 Dec 2018 09:51:28 by Kilian Hekhuis
Merged this idea with 'Copy an Aggregate and Paste as an Advanced Query' (created on 04 Jan 2017 11:56:48 by João Sousa)

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. 



This comment was:
- originally posted on idea 'Copy an Aggregate and Paste as an Advanced Query' (created on 04 Jan 2017 by João Sousa)
- merged to idea 'Transform Aggregate to Advanced Query' on 20 Dec 2018 09:52:14 by Kilian Hekhuis

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



This comment was:
- originally posted on idea 'Copy an Aggregate and Paste as an Advanced Query' (created on 04 Jan 2017 by João Sousa)
- merged to idea 'Transform Aggregate to Advanced Query' on 20 Dec 2018 09:52:14 by Kilian Hekhuis

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.



This comment was:
- originally posted on idea 'Copy an Aggregate and Paste as an Advanced Query' (created on 04 Jan 2017 by João Sousa)
- merged to idea 'Transform Aggregate to Advanced Query' on 20 Dec 2018 09:52:14 by Kilian Hekhuis
views
1311
Followers
21