Builtin & User functions
on 26 Sep 2018
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.

Created on 19 Jan 2017
Comments (5)

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:


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?