hiaLL , please help
i have 2tabes --transaction table(ELC:TRANSACTION ) and receipeiNT(ELC:RECEIPIENT) table and i want to create 1to many link between them in schema
In 1 to Many cardinality,
the code should be written in Target (Many-N) schema.
In the below example, I have written the code in ELC:TRANSACTION schema.
<element label="Recipient" name="recipient" revLabel="Recipient Trnsaction" target="elc:recipient" type="link">
<join xpath-dst="@id" xpath-src="@irecipientid"/>
</element>
SO THE code should be written like that according to me but
what i found is another adobe doc where its defined in diff way:
LINK
<element label="Recipient" name="lnkRecipient" revLink="lnkTransactions" target="elc:recipient" type="link"/>
please help me which one is correct method and what is the diff between the two
why so why it is using revlink.....we shoulsd use revlabel only
what and when we use revlink in schema
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @Shrutii ,
You can refer to the below solved post for revLink usage
Also, we can create temporary 1 to many Link using Enrichment activity(useful in calculating aggregates or temporary values useful for that particular Workflow) but if you want you can do it from the Schema level so that its not required to create every time in the Workflow.
For this use case:
<element label="Recipient" name="lnkRecipient" revLink="lnkTransactions" target="elc:recipient" type="link"/>
If we mention type="link" without explicitly mentioning the Joining keys, then Adobe Campaign will automatically consider the primary keys (they should have the same Data type ) in both the Schemas as the Joining keys. You can check it it Preview Tab of the Schema after adding the Link and Update DB Structure.
Regards,
Pravallika.
Hi @Shrutii,
Views
Replies
Total Likes
Hi @Shrutii ,
You can refer to the below solved post for revLink usage
Also, we can create temporary 1 to many Link using Enrichment activity(useful in calculating aggregates or temporary values useful for that particular Workflow) but if you want you can do it from the Schema level so that its not required to create every time in the Workflow.
For this use case:
<element label="Recipient" name="lnkRecipient" revLink="lnkTransactions" target="elc:recipient" type="link"/>
If we mention type="link" without explicitly mentioning the Joining keys, then Adobe Campaign will automatically consider the primary keys (they should have the same Data type ) in both the Schemas as the Joining keys. You can check it it Preview Tab of the Schema after adding the Link and Update DB Structure.
Regards,
Pravallika.
Views
Likes
Replies
Views
Likes
Replies