I try to set deltaquery > deltaImportQuery="SELECT * from users WHERE id='${dih.delta.id}'" > deltaQuery="SELECT id FROM users WHERE modified > > '${dataimporter.last_index_time}'"
But the database who i try to index dont have attribute modified just date_creation 2016-07-13 14:11 GMT+01:00 Jamal, Sarfaraz < sarfaraz.ja...@verizonwireless.com.invalid>: > Hi Kostali, > > I would look at the Delta Queries - > > Sas > > -----Original Message----- > From: kostali hassan [mailto:med.has.kost...@gmail.com] > Sent: Wednesday, July 13, 2016 5:17 AM > To: solr-user@lucene.apache.org > Subject: Update index > > I am using solr 5.4 1 to index sql database with data import handler. > I am looking for update index automatically when the database is modified > or insert in it new value. >