delta import on changes in entity within a document

[PeterKerk]

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.