Schema Integreity

[ItachiUchiha3]

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

[Craig_Thonis · Accepted solution]

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-integr...

<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-r...