Hi, I am able to get it done using following way -
<entity name="delete_from_index" pk="ID" transformer="TemplateTransformer" query="SELECT dbColumnName FROM dbTableName where pstate = 1 AND plast_modified_date > TO_DATE ('${dih.last_index_time}','YYYY-MM-DD HH24:MI:SS')" > <field column="$deleteDocByQuery" template="solrFieldName:${delete_from_index.dbColumnName}"/> <field column="ID" name="id"/> <field column="dbColumnName" name="solrFieldName"/> </entity> Thanks, Paresh -- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html