Dear Wiki user, You have subscribed to a wiki page or wiki category on "Solr Wiki" for change notification.
The following page has been changed by NoblePaul: http://wiki.apache.org/solr/DataImportHandler ------------------------------------------------------------------------------ <document name="products"> <entity name="item" pk="ID" query="select * from item" deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'"> - <field column="ID" name="id" /> - <field column="NAME" name="name" /> - <field column="NAME" name="nameSort" /> - <field column="NAME" name="alphaNameSort" /> - <field column="MANU" name="manu" /> - <field column="WEIGHT" name="weight" /> - <field column="PRICE" name="price" /> - <field column="POPULARITY" name="popularity" /> - <field column="INSTOCK" name="inStock" /> - <field column="INCLUDES" name="includes" /> - - <entity name="feature" pk="ITEM_ID" + <entity name="feature" pk="ITEM_ID" - query="select DESCRIPTION from FEATURE where ITEM_ID='${item.ID}'" + query="select DESCRIPTION as features from FEATURE where ITEM_ID='${item.ID}'" deltaQuery="select ITEM_ID from FEATURE where last_modified > '${dataimporter.last_index_time}'" - parentDeltaQuery="select ID from item where ID=${feature.ITEM_ID}"> + parentDeltaQuery="select ID from item where ID=${feature.ITEM_ID}"/> + - <field name="features" column="DESCRIPTION" /> - </entity> <entity name="item_category" pk="ITEM_ID, CATEGORY_ID" query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'" deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'" parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}"> <entity name="category" pk="ID" - query="select DESCRIPTION from category where ID = '${item_category.CATEGORY_ID}'" + query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'" deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'" - parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"> + parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/> + - <field column="description" name="cat" /> - </entity> </entity> </entity> </document>
