Sign in to Community
Sign in to view all badges
I have a predefined filter that contains two sub-filters in the definition. When I inspect the result of the new filter, I see duplicated records.
Is there some automatic setting/way to make sure that a pre-defined filter only contains distinct data?
(without actually modifying the criteria definition)
Predefined filters define where clauses for queries- not select clauses.
To select distinct records, use any of these: