Aggregate with distinct

By Ricardo Antunes on 5 Oct 2015
Aggregate should have an option to remove duplicates.

I see this as a new tab like "Sorting" where you could select the column you want to remove duplicates.
Kilian Hekhuis5 Oct 2015
Well, Simple Queries are the way of the past. From version 9, they are no longer available.
André Siébra5 Oct 2015
Well, I think I'm the only one that miss the Simple Queries... but we should let it go anyway...
Ricardo Antunes5 Oct 2015
Edit: I was talking about aggregate and not simple query.
Although we can work around this issue (by grouping all the fields) I still think there could be this way to simplify queries
Kilian Hekhuis6 Oct 2015
@Andre: I miss them too!

@Ricardo, agreed, like a DISTINCT
Ricardo Antunes6 Oct 2015
Edit: I was talking about aggregate and not simple query.
Although we can work around this issue (by grouping all the fields) I still think there could be this way to simplify queries
This idea is great.
I'm hoping to see this implemented as soon as possible.
Diogo Mota6 Oct 2015
Agree! the distinct option would improve the aggregates alot.
Filipe Ferreira6 Oct 2015
How could this not to be implemented yet?
@Ricardo, good idea!
Justin James6 Oct 2015
This was suggested 5 years ago for Simple Queries, marked as "Done" but never implemented as far as I know:

http://www.outsystems.com/ideas/260/distinct-select-possible-on-a-simple-query

Then again (with the same result) four years ago:

http://www.outsystems.com/ideas/846/distinct-parameter-in-simple-queries

This really is needed.

J.Ja
J.6 Oct 2015
yes!


Dan OnEo24 Jun
up
Please foresee this for aggregates