Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Predefined Fitlers: Result contains duplicated records

lulitg
Level 2
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
wodnicki
Correct answer by
Community Advisor
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
wodnicki
Correct answer by
Community Advisor
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

lulitg
Level 2
Level 2

Thanks Jon.

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