We have a reqirement to save data from three level of replicants into ONE TABLE in the database.
Here is a snippet from the Data Deploy FIle:
Here ID_DEMO_FIELD, NME_CONTACTS_GROUP and ID_CONTACT_INFO are the fields from different nested replicants but are saved in one table(BP_CONT_CONTACT_INFO) in the data base.
_____________________________________________________________________________
<group name="BP_CONT_CONTACT_INFO" table="BP_CONT_CONTACT_INFO" root-group="no">
<attrmap>
<column name="ID_CONTENT" data-type="NUMBER" value-from-field="ID_CONTENT" allows-null="no" />
<column name="ID_DEMO_FIELD" data-type="NUMBER" value-from-field="demo/[0-10]/demoselect" is-replicant="yes" allows-null="yes" />
<column name="NME_CONTACTS_GROUP" data-type="VARCHAR2(255)" value-from-field="demo/[0-10]/contactGroup/[0-10]/ContactGroupName" is-replicant="yes" allows-null="yes" />
<column name="ID_CONTACT_INFO" data-type="NUMBER" value-from-field="demo/[0-10]/contactGroup/[0-10]/contact/[0-15]/ID_CONTACT_INFO" is-replicant="yes" allows-null="no" />
</attrmap>
<keys>
<primary-key>
<key-column name="ID_CONTACT_INFO" />
<key-column name="ID_CONTENT" />
</primary-key>
_______________________________________________________________________________________________________
Using this snippet, the DCR gets deployed but the data is not getting populated in the BP_CONT_CONTACT_INFO table.
With the same logic, if we have just two levels of replicants the data get saved in the table as required.
Following are the data deploy logs:
____________________________________________________________________________________________
GetCurrentRowsFromGroupInfo: 0 rows selected from BP_CONT_CONTACT_INFO
TTableSchemaHelper object for [BP_CONT_CONTACT_INFO] found in cache.
SelectCurrentRows
ELECT IND_CONTACT_INFO_PRIORITY,ID_DEMO_FIELD,NME_CONTACTS_GROUP,NME_CONTACT,NME_JOB_TITLE,NME_OFFICE,DSC_JOB_DESCRIPTION,ID_ASSET_CONTACT_IMAGE,NME_CONTACT_IMAGE_ALT,DSC_ADDRESS1,DSC_ADDRESS2,DSC_ADDRESS3,NME_CONTACT_PHONE,NME_EMAIL,NME_FAX,NME_WEBSITE,DSC_CONTACT_NOTE,ID_CONTACT_INFO,ID_CONTENT FROM BP_CONT_CONTACT_INFO WHERE ID_CONTENT = ? ORDER BY ID_CONTACT_INFO,ID_CONTENT
Column: ID_CONTENT, field: ID_CONTENT, Index: 1,Converting '3072045' to DECIMAL
SelectCurrentRows: 0 rows selected.
Building Row map tree for group [BP_CONT_CONTACT_INFO].
This may take a while....
Row map tree for group [BP_CONT_CONTACT_INFO] built.
TTableSchemaHelper object for [BP_CONT_CONTACT_INFO] found in cache.
DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
1 rows inserted into iwdeltracker for templatedata/learn_more/contact_information/data/test_pavan_2.dcr, /default/main/bp_internet/solar/bp_solar_global/bp_solar_global_english/WORKAREA/working
-- Updated
______________________________________________________________________________________
If any one has encountered similar issues or can give us some pointers in resolving this, it will be of great help.
Thanks,
Himnashu.
