I want to show the new avatar of an ad as soon as the thumbid value of that ad is updated.
This is what I had before delta query which works all fine: <document name="ads"> <entity pk="id" name="ad" query="select * from ads WHERE approvedate > '1/1/1900' and publishdate < getdate() AND depublishdate > getdate() and deletedate = '1/1/1900'" deltaImportQuery="select * from ads WHERE approvedate > '1/1/1900' and publishdate < getdate() AND depublishdate > getdate() and deletedate = '1/1/1900' and id='${dataimporter.delta.id}'" deltaQuery="select id from ads where updatedate > '${dataimporter.last_index_time}'"> <field name="id" column="ID" /> <field name="userid" column="userid" /> <field name="thumbid" column="thumbid" /> <entity name="ad_thumb" query="SELECT locpath = ISNULL((select locpath FROM ad_photos where id='${ad.thumbid}'),'')" <field name="thumb" column="locpath" /> </entity> </entity> </document> in my schema.xml I have this field: <field name="thumb" type="text" indexed="true" stored="true"/> Here's the definition of ad_photos table: CREATE TABLE [dbo].[ad_photos]( [id] [int] IDENTITY(1,1) NOT NULL, [adid] [int] NOT NULL, [locpath] [nvarchar](150) NOT NULL, [title] [nvarchar](50) NULL, [createdate] [datetime] NOT NULL, CONSTRAINT [PK_ad_photos] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO Now Im trying to add delta query functionality to the ad_thumb entity... Now my guess is that the problem is that nowhere is saved WHEN the thumbid was changed, the only place where the new thumb is updated is when the value of column [ad].[thumbid] has changed, but without a timestamp. I tried this: <entity name="ad_thumb" query="SELECT locpath = ISNULL((select locpath FROM ad_photos where id='${ad.thumbid}'),'')" deltaImportQuery="SELECT locpath = ISNULL((select locpath FROM ad_photos where id='${dataimporter.delta.id}'),'')" deltaQuery="SELECT locpath = ISNULL((select locpath FROM ad_photos where createdate > '${dataimporter.last_index_time}'"> <field name="thumb" column="locpath" /> </entity> But as you can see it doenst really make sense...:$ I have no idea how to approach this and if its possible without having the timestamp of thumb changed date. -- View this message in context: http://lucene.472066.n3.nabble.com/Delta-import-possible-when-no-timestamp-of-specific-field-is-set-tp3163190p3163190.html Sent from the Solr - User mailing list archive at Nabble.com.