Predefined Fitlers: Result contains duplicated records

[lulitg]

Hello,

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)

[Jonathon_wodnicki · Accepted solution]

Hi,

Predefined filters define where clauses for queries- not select clauses.

To select distinct records, use any of these:

• Complementary information ('select') section of the query UI, under Advanced parameters
• Complementary information, group by
• Deduplication activity

Thanks,

-Jon

[lulitg]

Thanks Jon.

Not exactly what I was hoping for but clarifies the capabilities.