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!


Ricardo Antunes7 Mar 2016
up
Please foresee this for aggregates
Ricardo Antunes16 Aug 2016

up

Alex Dellinger14 Dec 2016

DO IT!!

But why are we creating duplicates?

Because my join creates them?

Up! Please don't make me do another list to sort distinct again.

Yes, distinct would be helpful

Rocky27 Oct

Hey ,  alternate way to distinct  a Aggregate get to append all  to list record and distinct that list record using  DISTINCTRECORDLIST  in  SORTRECORDLIST component. 

@Rocky yes, but that takes extra time, especially for long lists, and also forces the entire query output to be retrieved, which can degrade performance.

As for a workaround, you can Group on all the output columns you need, which will implicitely make them distinct. Also not a very nice solution, but better than post-processing.

PLEASE DO IT!!!

I Box8 Nov

just do it!

Hopefully, the aggregate accomodates all the Advanced Query's capabilities as easy as possible.

regards,

bb

Certainly!


Agno Silveira1 Dec (2 weeks ago)

Please do it.