Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Predefined Fitlers: Result contains duplicated records

Avatar

Level 2

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)

1 Accepted Solution

Avatar

Correct answer by
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

View solution in original post

2 Replies

Avatar

Correct answer by
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

Avatar

Level 2

Thanks Jon.

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