You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Sudheer (JIRA)" <ji...@apache.org> on 2018/10/08 14:08:00 UTC

[jira] [Updated] (SOLR-12841) not able to use deleteDocByQuery

     [ https://issues.apache.org/jira/browse/SOLR-12841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sudheer updated SOLR-12841:
---------------------------
    Summary: not able to use deleteDocByQuery  (was: how i can use deleteDocByQuery)

> not able to 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
>            Priority: Critical
>
> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org