Predefined Fitlers: Result contains duplicated records

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)

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Jonathon_wodnicki

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

Accepted solution

Community Advisor

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

Level 2

Thanks Jon.

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

Sign up