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

Filtering on FDA tables

Avatar

Avatar
Validate 1
Level 1
timg96297954
Level 1

Likes

2 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
timg96297954
Level 1

Likes

2 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
timg96297954
Level 1

26-06-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

03-07-2017

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.

Answers (0)