I am assuming that you are using a recent version of DIH.
I see some discrepency in the queries
SELECT Sub0.SUBID ... is the deltaQuery
and the join is done using
Sub0.SUBID =${dataimporter.delta.SUBID}" in deltaImportQuery
try making the first query as SELECT Sub0.SUBID as SUBID
or making the join as
Sub0.SUBID =${dataimporter.delta.Sub0.SUBID}"
On Wed, Mar 18, 2009 at 9:00 PM, Rui Pereira <ruipereira...@gmail.com> wrote:
> I have the following root entity:
>
> <entity name="3142" pk="SUBID" preImportDeleteQuery="topologyid:3142"
> query="SELECT DISTINCT '3142-' || Sub0.SUBID as id, 'Topology name' as
> topologyname, 3142 as topologyid, Sub0.subid, Sub0.NAME as instancename FROM
> Sub Sub0"
> deltaQuery="SELECT Sub0.SUBID FROM Sub Sub0 LEFT JOIN SubPlace SubPlace1
> ON Sub0.SUBID = SubPlace1.SUBID LEFT JOIN Place Place1 ON SubPlace1.PLACEID
> = Place1.PLACEID LEFT JOIN PType PType2 ON Place1.PTYPEID = PType2.PTYPEID
> LEFT JOIN SType SType3 ON Sub0.STYPEID = SType3.STYPEID WHERE
> (to_char(Sub0.lastmodifieddate, 'YYYY-MM-DD HH24:MI:SS') >
> '${dataimporter.last_index_time}' OR to_char(Place1.lastmodifieddate,
> 'YYYY-MM-DD HH24:MI:SS') > '${dataimporter.last_index_time}')"
> deltaImportQuery="SELECT DISTINCT '3142-' || Sub0.SUBID as id,
> 'Topology name' as topologyname, 3142 as topologyid, Sub0.subid, Sub0.NAME
> as instancename FROM Sub Sub0 WHERE Sub0.SUBID =
> ${dataimporter.delta.SUBID}">
> <field column="ID" name="id" />
> <field column="TOPOLOGYNAME" name="topologyname" />
> <field column="TOPOLOGYID" name="topologyid" />
> <field column="SUBID" name="instancekey" />
> <field column="INSTANCENAME" name="instancename" />
> <entity name="allattributes"
> query="SELECT DISTINCT Sub0.NAME AS SubNAME0, Place1.NAME AS
> PlaceNAME1, PType2.NAME AS PTypeNAME2, SType3.NAME AS STypeNAME3 FROM Sub
> Sub0 LEFT JOIN SubPlace SubPlace1 ON Sub0.SUBID = SubPlace1.SUBID LEFT JOIN
> Place Place1 ON SubPlace1.PLACEID = Place1.PLACEID LEFT JOIN PType PType2 ON
> Place1.PTYPEID = PType2.PTYPEID LEFT JOIN SType SType3 ON Sub0.STYPEID =
> SType3.STYPEID WHERE Sub0.SUBID = ${3142.SUBID}">
> <field column="SUBNAME0" name="attributevalue" />
> <field column="PLACENAME1" name="attributevalue" />
> <field column="PTYPENAME2" name="attributevalue" />
> <field column="STYPENAME3" name="attributevalue" />
> </entity>
> </entity>
>
> I get results when running the deltaQuery manually, but Solr doesn't import
> anything!!!
> What am I doing wrong?!
>
> Thanks in advance,
> Rui Pereira
>
--
--Noble Paul
