How to setup links integrity? | Community
Skip to main content
Level 3
Jul 26, 2018 2:59 PM UTC
Solved

How to setup links integrity?

I have these 2 schemas:

<srcSchema entitySchema="xtk:srcSchema" img="xtk:schema.png" label="Consent Log"

           name="consentLog" namespace="li" xtkschema="xtk:srcSchema">

<element autopk="true" label="Consent Log" name="consentLog">

    <attribute label="Customer Id" length="36" name="customerId" type="string"/>

    <element label="Customer" name="customer" target="li:customer" type="link">

      <join xpath-dst="@customerId" xpath-src="@customerId"/>

    </element>

    <element label="Consent" name="consent" target="li:consent" type="link"/>

  </element>

</srcSchema>

<srcSchema entitySchema="xtk:srcSchema" img="xtk:schema.png" label="Trial Registration Consent"

           name="trialRegistrationConsent" namespace="li" xtkschema="xtk:srcSchema">

  <element autopk="true" label="Trial Registration Consent" name="trialRegistrationConsent">

    <element label="Consent Log" name="consentLog" revCardinality="single" revIntegrity="own"

             target="li:consentLog" type="link"/>

    <element label="Trial Registration" name="trialRegistration" target="li:trialRegistration"

             type="link"/>

  </element>

</srcSchema>

What I want from them is the following: If someone (Workflow, User manually, any JS code) will delete item from li:consentLog I want corresponding item to be deleted from li:trialRegistrationConsent.

This doc (https://docs.campaign.adobe.com/doc/AC/en/CFG_Schema_Reference_Database_mapping.html#Links-_relation_between_tables ) says I need revIntegrity to be "own". But it doesn't work or I don't understand the doc. Help pls.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
pablo_rosero1
pablo_rosero1Accepted solution
Level 9
Nov 28, 2018 5:56 AM UTC

Hi Andrey,

Here you can find Examples of revIntegrity.

I hope this helps!

All the best,

Pablo

3 replies

pablo_rosero1
pablo_rosero1Accepted solution
Level 9
Nov 28, 2018 5:56 AM UTC

Hi Andrey,

Here you can find Examples of revIntegrity.

I hope this helps!

All the best,

Pablo

Translate
Level 3
Jul 27, 2018 8:55 AM UTC

Hi Adhiyan,

Nope. when deleting li:consentLog li:trialRegistrationConsent is still not deleting.

Translate
Adhiyan
Employee
Jul 26, 2018 4:03 PM UTC

Hi Andrey,

Can you try and use integrity="own" instead of revIntegrity and see if the deletion of source and target works correctly.

Regards,Adhiyan

Translate