how do you know it is not being executed ?. use deltaImportQuery also if you are using Solr1.4
On Sat, May 23, 2009 at 4:29 AM, Michael Korthuis <michael.korth...@twintechs.com> wrote: > 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> > -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com