P10 introduced new operations over lists: ListAll, ListAny, ListFilter, ListIndexOf and ListSort.
But, it's still missing a very usefull operation: ListDistinct
We are still using SortRecordList extension just because of this functionality. It would be nice if it could be added to the system module.
My thoughts exactly, I was surprised it wasn't included in P10!
Most of the times Distinct could be prevented by another query, but sometime (by the nature of queries within OutSystems) it could be a usefull addition to prevent a requery to the database to populate lists.
Not a huge fan, but I see its potential on some occassions
Hi guys,
Just to let you know that we'll be working on these soon!
Stay tuned :)
Hey guys,
I'm glad to announce that, with the release of OutSystems 11, there is a new List Distinct action. As usual, a special thank you to the idea creator, Carlos, in our release notes.
Hope you enjoy it!
Don't forget to check OutSystems 11 what's new to see all the new features that were released:
https://success.outsystems.com/Documentation/11/New_in_OutSystems_11
On what criteria will the ListDistinct try to filter? Lets say I have a list of structure with 100 attributes. Will all 100 attributes be considered to find a distinct entry? What If I just need to get distinct list based on an attribute?