Builtin & User functions
Development Environment

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 :)

Changed the status to
on 26 Sep 2018

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:

Goldy Lukka

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?

Daniël Kuhlmann

Hi Goldy, your question is better asked on the forum, not on the ideas page.

Hi Daniel, Actually it was question on the idea and Not the feature :-)

Daniël Kuhlmann

The Idea is implemented, so in my opinion it is a question on the build in function ListDistinct.

Ok, the feature does Not support it. Can I post a new Idea instead of asking question on the same Idea?

Daniël Kuhlmann

The feature does not support it, so yes the best is to create a new idea, not to tag along in an idea that has already the status  "Implemented".