not able to use deleteDocByQuery: please provide detailed example

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

not able to use deleteDocByQuery: please provide detailed example

Sudheer Shinde
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>
Reply | Threaded
Open this post in threaded view
|

not able to use deleteDocByQuery: please provide detailed example

Sudheer Shinde
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>
Reply | Threaded
Open this post in threaded view
|

Re: not able to use deleteDocByQuery: please provide detailed example

Chris Gerke
UNSUBSCRIBE

On Tue, 9 Oct 2018 at 4:36 am, Sudheer Shinde <[hidden email]>
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>
>
Reply | Threaded
Open this post in threaded view
|

Re: not able to use deleteDocByQuery: please provide detailed example

Erick Erickson
Chris:

Please follow the instructions here:
http://lucene.apache.org/solr/community.html#mailing-lists-irc. You
must use the _exact_ same e-mail as you used to subscribe.

If the initial try doesn't work and following the suggestions at the
"problems" link doesn't work for you, let us know. But note you need
to show us the _entire_ return header to allow anyone to diagnose the
problem.

Best,
Erick
On Mon, Oct 8, 2018 at 2:48 PM Chris Gerke <[hidden email]> wrote:

>
> UNSUBSCRIBE
>
> On Tue, 9 Oct 2018 at 4:36 am, Sudheer Shinde <[hidden email]>
> 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>
> >