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>
