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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Filtering on FDA tables

Avatar

Level 2

Hi guys,

I am trying to set a filter on a remote table (FDA).

The remote table is connected with the recipient table in a 1:N relationship:

1237744_pastedImage_0.png

Now I want to set a filter on the remote table:

1237745_pastedImage_1.png

And get the following error:

1237746_pastedImage_2.png

When I set up a selection with the remote table as the filtering dimension, it works.

But I want to set the filter in the interaction engine and there is no filtering dimension, so I want to set the filter directly on the remote table.

Do you know why I get this error?

Kind regards

Tim

Merken

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Tim,

It is generally recommended not to perform:

  • queries on high volume 1-N related tables
  • queries on 1-N related tables connected through FDA

This is for performance reasons mostly and the reason why it is working better when working on a different filtering dimension.

I'd recommend to try by applying the recommendations mentioned here: Accessing an external database.

Also, can you share your server and console versions?

Please let me know how it goes,

Florent.

1 Reply

Avatar

Correct answer by
Level 10

Hi Tim,

It is generally recommended not to perform:

  • queries on high volume 1-N related tables
  • queries on 1-N related tables connected through FDA

This is for performance reasons mostly and the reason why it is working better when working on a different filtering dimension.

I'd recommend to try by applying the recommendations mentioned here: Accessing an external database.

Also, can you share your server and console versions?

Please let me know how it goes,

Florent.