hi all, please help me
i need to crate a 1to 1 link between customer schema and country schema
please help me with syntax,i checked the documentaion but its somewhat confusiing
we can write the link definition in any of the schema in 1to1 cardinality
is this correct ,i have written this in country schema
<element revCardinality="single" label="customer " name="customer " revLabel="linkcountry" target=elc:customer" type="link"> <join xpath-dst="@ID " xpath-src="@countryid "/></element>
what if i have to define this 1to 1 link in recipient schema but not in country scheam,please help me on code please
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @Shrutii ,
Logically the relationship between a country table and customer table is 1 to Many.
But in general if you want to create 1 to 1 link between 2 schema, then you can write the join script in any of the schema. Example, if you write the join script in Table A, mention target="abc:table_B" in element tag. And if you decide to write the join script in Table B, mention target="abc:table_A" in element tag.
Hi @Shrutii
rev Cardinality is the reverse cardinality which you will b defining, if you have written the code in country schema then single cardinality will be create in the reverse way, ie, from recipient to country schema and vice versa. Reverse link [from recipient to country] will have single Recipient will have only one country (1-1) but forward [from country to recipient] will be one Country will have many recipients (1-N).
For more details you can visit the documentation.
Regards
Akshay
Hi @Shrutii ,
Logically the relationship between a country table and customer table is 1 to Many.
But in general if you want to create 1 to 1 link between 2 schema, then you can write the join script in any of the schema. Example, if you write the join script in Table A, mention target="abc:table_B" in element tag. And if you decide to write the join script in Table B, mention target="abc:table_A" in element tag.
Views
Likes
Replies