Hi,
I am trying to write an entity to delete documents for the records marked as
deleted in my rdbms database using db-data-config.xml file with following
entry in an entity -
query="SELECT CONCAT( 'ColName:', dbCol ) AS '$deleteDocByQuery' FROM TABLE1
t1 WHERE t1.state = 1 AND t1.lmd > TO_DATE
('${dih.last_index_time}','-MM-DD HH24:MI:SS')"
Through SOLR-Admin UI I am selecting "delta-import", entity-name and giving
proper jdbc string in custom-parameters.
I have marked the ColName represented in Solr as deleted in RDBMS Table1
using state column value of 1.
ColName is Solr column-name for the collection. dbCol - database column name
in Table1
I am trying to use $deleteDocByQuery clause to remove documents.
Any help is appreciated.
Regards,
Paresh
--
Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html