Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
replicants and IWExternalDataSource
bikerider
I am using IWExternalDataSource and wish to get the values from a field which is a replicant in the DCT. How do I make DD call me as a replicant? It only calls me one time with the following configuration. The guide_book_id in the following example is a replicant. I.e. if I were to not use the IWExternalDataSource, it would look like:
value-from-field="TeamSite/Metadata/guide_book_rep/[0-30]/guide_book_id"
<group name="software_guide_book" table="$tableprefix^SOFTWARE_GUIDE_BOOK" root-group="no">
<attrmap>
<column name="software_id" data-type="NUMBER" value-from-callout="iwov:dd:java:com.ti.datadeploy.SwDelExternalDataSource" allows-null="no"/>
<column name="guide_book_id" data-type="NUMBER" value-from-callout="iwov:dd:java:com.ti.datadeploy.SwDelExternalDataSource" allows-null="no" />
<column name="DATE_CREATED" data-type="DATE" value-from-field="crdate" data-format="MM/dd/yyyy HH:mm:ss" allows-null="no"/>
<column name="CREATED_BY" data-type="varchar2(60)" value-from-field="creator" allows-null="no"/>
<column name="DATE_MODIFIED" data-type="DATE" value-from-field="moddate" data-format="MM/dd/yyyy HH:mm:ss" />
<column name="MODIFIED_BY" data-type="VARCHAR2 (60)" value-from-field="lastuser" />
</attrmap>
<keys>
<primary-key>
<key-column name="software_id"/>
</primary-key>
</keys>
<foreign-key parent-group="software_catalog" ri-constraint-rule="ON DELETE CASCADE">
<column-pair parent-column="id"
child-column="guide_book_id"/>
</foreign-key>
<exists-sql>
<!-- Must check for synonymn and table -->
SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME = '$tableprefix^SOFTWARE_GUIDE_BOOK'
UNION
SELECT TABLE_NAME FROM ALL_SYNONYMS WHERE TABLE_NAME = '$tableprefix^SOFTWARE_GUIDE_BOOK'
</exists-sql>
</group>
Find more posts tagged with
Comments
There are no comments yet