delta import on changes in entity within a document

[PeterKerk <pe...@hotmail.com>]

I have the following data-config:

    <document name="locations">
        <entity pk="id" name="location" query="select * from locations WHERE
isapproved='true'"
		deltaImportQuery="select * from locations WHERE updatedate &lt; getdate()
AND isapproved='true' AND id='${dataimporter.delta.id}'"
		deltaQuery="select id from locations where isapproved='true' AND
updatedate &gt; '${dataimporter.last_index_time}'">
		
		
		
			<entity name="offerdetails" query="SELECT title as
offer_title,ISNULL(img,'') as offer_thumb,id as offer_id
			,startdate as offer_startdate
			,enddate as offer_enddate
			,description as offer_description
			,updatedate as offer_updatedate
			FROM offers WHERE objectid=${location.id}">
			</entity>				
	</document>
	
	
Now, when the object in the [locations] table is updated, my delta import
(/dataimport?command=delta-import) query works perfectly.
But when an offer is updated in the [offers] table, this is not seen by the
deltaimport command. Is there way to delta-import only the updated offers
for the respective location if an offer is updated? And then without:
a. having to fully import ALL locations 
or 
b. having to update this single location and then do a regular deltaimport?



--
View this message in context: http://lucene.472066.n3.nabble.com/delta-import-on-changes-in-entity-within-a-document-tp4195615.html
Sent from the Solr - User mailing list archive at Nabble.com.