Make Simple Queries available in version 9 along with Aggregates

By Romeu Azevedo on 26 Feb 2015
No one have doubts about that aggregates are very powerful but in lot of cases the Simple Queries do the same and are more appropriate.
The main reasons for this idea is this post. And I just passed to an Idea to know how much developers agreed with this so Outsystems can bring back Simple Query since the code is already there.
Thanks and Version 9 is awesome!
Kilian Hekhuis26 Feb 2015
This. Also, have the possibility to back-convert aggregates into simple queries again. We're currently already on Platform 9, and have 1000s of converted Simple Queries...
José Amaral14 Mar 2015
Why replace good old Simple Query with this aggregate-cant-see-it-all-at-once-stays-in-full-screen-query ?

Bring Back Simple Query!

Merged from 'Bring Back Simple Query!' (idea created on 2015-03-14 00:30:49 by José Amaral), on 2015-04-22 10:18:45 by Goncalo Borrega
Gonçalo Almeida24 Mar 2015
I like the aggregate, but there are a couple of things that could be made to improve it:

- a way to see instantly what "input parameters" we are using (we have to go through filters to know);

- a faster way to create joins. On a simple query we just choose the 2 entities and it would imediatly create a join. Now, we have to create it from scratch. I'd like the aggregate to suggest a join immediately after adding a source entity, then we could alter it if that would be the case. Altering a thing is faster than creating it from scratch;

- If the aggregate has zero sources (you are creating a new blank one) it's a pain to add a source. Instead of just allowing us to drag & drop entities, the link "Sources" could be available for us as well;

- In the "sorting" part of the aggregate, sometimes it's a pain to add a column, if there are many entities. You have to search through all the horizontal screen for the column you want. I don't have a specific idea, but please think of something to improve this and make it faster;


Merged from 'Bring Back Simple Query!' (idea created on 2015-03-14 00:30:49 by José Amaral), on 2015-04-22 10:18:46 by Goncalo Borrega
José Amaral7 Apr 2015


We would all be very thankfull :)

Merged from 'Bring Back Simple Query!' (idea created on 2015-03-14 00:30:49 by José Amaral), on 2015-04-22 10:18:46 by Goncalo Borrega
J.8 Apr 2015
- it annoys the hell out of me when i drag and drop 1 entity, I get 5 entities + joins for free..

- the preview of test-data is nice, but it slows my development when i tweak the filters/joins

- copy data is impossible for testing purposes.. (using other emails)

- "group by" will f* up the tablerecords.




Merged from 'Bring Back Simple Query!' (idea created on 2015-03-14 00:30:49 by José Amaral), on 2015-04-22 10:18:46 by Goncalo Borrega