Predefined Fitlers: Result contains duplicated records

Avatar

Avatar

lulitg

Avatar

lulitg

lulitg

23-04-2020

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)

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

24-04-2020

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

Answers (0)