Re: Solr 7.7.0: Log file not getting generated

[Paresh]

Hi Paras,

I have db-data-config.xml file with entities defined for data population and
update.

As a part of some process, I want to delete the documents from Solr for data
deleted in RDBMS. For this purpose I am writing SQL to fetch data from RDBMS
and delete it in Solr using $deleteDocByQuery.

I want to debug if the query getting formed is correct or not -

Here is the snippet of entity -

        <entity name="delete_docs" pk="ID" query="SELECT CONCAT(
'SolrFieldName:', dbColumnName ) AS &amp;quot;$deleteDocByQuery&amp;quot;
FROM DBTableName t1 WHERE t1.pstate = 1 AND t1.plast_modified_date &amp;gt;
TO_DATE ('${dih.last_index_time}','YYYY-MM-DD HH24:MI:SS')">
            <field column="ID" name="id"/>
            <field column="PRODUCT"
name="TC_0Y0_ProductScope_0Y0_product_uid"/>
        </entity>

The said entity, I am not able to delete the docs from solr using
delta-import operation, so wanted to debug it.

Regards,
Paresh



--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html