I have the data-config.xml detailed below (Stripped down a bit for
simplicity) -
When I run the delta import, the design_template delta query is running and
modified rows are being returned. However, the parentDeltaQuery is never
executed.
Any thoughts?
Thanks,
Micahael
<dataConfig>
<dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="URL"
user="USER" password="PASSWORD"/>
<document name="catalog_item_doc">
<entity name="catalog_item" transformer="script:catalog_item"
pk="catalog_item_id"
query="select catalog_item_id,catalog_item_code from catalog_item"
deltaQuery="select catalog_item_id from catalog_item where date_updated >
'${dataimporter.last_index_time}'"
deletedPkQuery="select catalog_item_id from catalog_item_delete where
date_deleted > '${dataimporter.last_index_time}'"
>
<field column="catalog_item_code" name="catalog_item_code" />
<entity name="design_template" transformer="script:stone_type"
id="design_template_id" pk="design_template_id"
query="select name from design_template where
design_template_id='${catalog_item.design_template_id_fk}'"
deltaQuery="select design_template_id from design_template where
date_updated > '${dataimporter.last_index_time}'"
parentDeltaQuery="select catalog_item_id from catalog_item where
design_template_id_fk = '${design_template.design_template_id}'"
>
<field column="name" name="name" />
</entity>
</entity>
</document>
</dataConfig>
