Schema Integreity | Community
Skip to main content
I
ItachiUchiha3
Level 2
September 9, 2022
Solved

Schema Integreity

  • September 9, 2022
  • 1 reply
  • 1247 views

Hi, 

I have 2 schemas recipient and cart details and both are linked by 1:N cardinality with custumer id as joining column. I have specified the link in cart details schema. My use case is If i delete customer id from recipient schema automatically records corresponding to that customer in cart deatils schema should be deleted.

 

I am using below code for linking in cart details schema:

<element label="Recipient" name="recipient" revIntegrity="own" revLink="Cart Details"
target="nms:recipient" type="link">
<join xpath-dst="@customerId" xpath-src="@customerId"/>
</element>

But the above code is not working. If i delete customer id in recipient corresponding cart details data is not getting deleted. Can anyone please what is wrong in the code and help to resolve this issue

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi Rahul,

 

Check out a similar situation in the forum link below. It looks like the example code provided is similar but the "integrity" is also defined, not just the revIntegrity.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/referential-integrity-cascade-delete/td-p/305176

 

<element integrity="neutral" label="Recipient" name="recipient" revIntegrity="own"revLabel="Subscriptions" target="nms:recipient" type="link"/>

 

Additional documentation around the rules:
https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-reference/database-mapping.html?lang=en

 

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
September 9, 2022

Hi Rahul,

 

Check out a similar situation in the forum link below. It looks like the example code provided is similar but the "integrity" is also defined, not just the revIntegrity.

 

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/referential-integrity-cascade-delete/td-p/305176

 

<element integrity="neutral" label="Recipient" name="recipient" revIntegrity="own"revLabel="Subscriptions" target="nms:recipient" type="link"/>

 

Additional documentation around the rules:
https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-reference/database-mapping.html?lang=en

 

    Terms & ConditionsAccessibility statement

    Loading footer...