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

Filtering on FDA tables

timg96297954
Level 2
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
florentlb
Correct answer by
Level 10
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.

View solution in original post

1 Reply
florentlb
Correct answer by
Level 10
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.

View solution in original post