Recipient Form and 1-1 link with non existing data

Avatar

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
Bruno_Cotrim
Level 2

02-05-2019

Good afternoon guys,


I'm having a issue while designing the form that presents the Recipient data.

In the Database I've satellite tables that might or not be populated if this recipient has that kind of characteristics, our recipient form is use only as a way to see information about a recipient and I'm designing it around that concept, by hinding the contexts that this recipient does not include, for example he might or not be part of the loyalty program and will only have an entry in the loyalty table if he does belong to it.

I can hide the data via the use of containers but ACC tries to load it non the less and throws out an error saying that such data does not exist (it is not suppose to).

So my question is how to prevent ACC from loading data about a recipient that it does not have and is not supposed to?

How the container is at the moment:

contatiner.JPG

The actual error:

eror data.JPG


Kind Regards,

Bruno Cotrim

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

03-05-2019

Hi Bruno,

The error displayed may depends on the schema source definition for your satellite tables, dblink, if you used reverse link or not, etc.

Please describe how you manage the relationship depending on the cardinality 0:n or 0:1 or n:n, with reverse link or not (reverseCardinality, etc) ?

Please in case of elements of type link, most of time used for lookup tables (referential tables) values to display in the main form (here recipient), may you also share the <join xpath-dst="@DSTKEY_ID" xpath-src="@SRCKEY_ID"/> in the element of type="link" of the schema customized cus:recipient (or whatever the prefix)?

But it seems that it is not your issue in your case.

Example with my own nms:recipient form:

<!-- Shop orders -->

  <container img="nms:reserveOrder.png" label="Shop orders" readOnly="true">

    <container colspan="2" label="Shop orders list" type="visibleGroup" visibleIf="[SHOP_ORDERS-Nms-Recipient_XXX_ID/@XXX_ID]= [InfosYYY/@MasterId] AND [SHOP_ORDERS-Nms-Recipient_XXX_ID/@XXX_ID] != 0">

(XXX and YYY replacement for security reasons.).

Moreover, most of times, it is highly recommended to insert a record with ID = 0 value in each satellite table, because Adobe Campaign simulates external join to avoid performance issues.
I don't find easily where it is written in the online documentation, but I am sure this is documented.

Regards
J-Serge

Answers (2)

Answers (2)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

986 likes

Total Posts

1,097 posts

Correct reply

518 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

986 likes

Total Posts

1,097 posts

Correct reply

518 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

02-05-2019

Hi,

Remove the xpath from the container node.

Thanks,

-Jon

Avatar

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Bruno_Cotrim
Level 2

Likes

5 likes

Total Posts

9 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
Bruno_Cotrim
Level 2

03-05-2019

Hey Jon,


Just tried that and it still throws the error out...

This is the complete structure of the container:

Form Capture.JPG

Edit: I also tried removing the container with the linklist unfortunately same thing 😕

Kind Regards,

Bruno Cotirm