UNSUBSCRIBE On Tue, 9 Oct 2018 at 4:36 am, Sudheer Shinde <sudheershin...@gmail.com> wrote:
> solr 6.2.1: > > my schema: > > id is primary key here: > > <field name="id" type="string" indexed="true" stored="true" > required="true" multiValued="false"/> > <field indexed="true" multiValued="false" docValues="true" > name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false" > stored="false" type="string"/> > <field indexed="true" multiValued="false" docValues="true" > name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/> > <field indexed="true" multiValued="false" docValues="true" > name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true" > type="string"/> > > > > I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid: > > my db-data config file: > <entity name="onlydeleteByQuery" pk="pproduct" > transformer="TemplateTransformer" > query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted > = 1" > > <field column="${deleteDocByQuery}" > > template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/> > <field column="ID" name="id" /> > <field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" /> > <field column="POBJECT" name="TC_0Y0_Item_uid" /> > <field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" /> > </entity> >