Sudheer created SOLR-12841:
------------------------------

             Summary: how i can use deleteDocByQuery
                 Key: SOLR-12841
                 URL: https://issues.apache.org/jira/browse/SOLR-12841
             Project: Solr
          Issue Type: Bug
      Security Level: Public (Default Security Level. Issues are Public)
    Affects Versions: 6.6.2
            Reporter: Sudheer


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>

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to