how to perform a delta-import when related table is updated

[PeterKerk]

My delta-import
(http://localhost:8983/solr/freemedia/dataimport?command=delta-import) does
not correctly update my solr fields.


Please see my data-config here:
        <entity name="freemedia" query="select * from freemedia WHERE
categoryid>0"
                deltaImportQuery="select * from freemedia WHERE updatedate &lt; 
getdate()
AND id='${dataimporter.delta.id}' AND categoryid>0"
                deltaQuery="select id from freemedia where updatedate &gt;
'${dataimporter.last_index_time}' AND categoryid>0">            

                
         <entity name="lovecount" query="select COUNT(id) as likes FROM
freemedialikes WHERE freemediaid=${freemedia.id}"></entity>                     
        

Now when a new item is inserted into [freemedialikes]
and I perform a delta-import, the Solr index does not show the total new
amount of likes. Only after I perform a full-import
(http://localhost:8983/solr/freemedia/dataimport?command=full-import) the
correct number is shown.
So the SQL is returning the correct results, I just don't know how to get
the updated likes count via the delta-import.

I have reloaded the data-config everytime I made a change. 



--
View this message in context: 
http://lucene.472066.n3.nabble.com/how-to-perform-a-delta-import-when-related-table-is-updated-tp4032587.html
Sent from the Solr - User mailing list archive at Nabble.com.