Unique values from object class

How do i filter the object class to only keep the unique values?

Ex. I have a object class with “Members” the person in Members can have several roles, in my unique object class i want it to list only one of every person. I have seen it been done before by @Thomas Hesselberg, but i dont remember how.

Hi!

If you have Person and Members, where Members is having multiple entries per Person (with diffent Roles): for example, it holds “John, Administrator”, “John, Employee”, “Paula, External”, “Lisa, HR”, “Lisa, Employee”.

To get the unique persons in the Members datasource, read the Persons data source with filter Person.ID exists in Members.Person. Now, the Persons data source holds John, Paula and Lisa.

Hope that helps.

Of course you can do it that way, thanks!

1 Like