Get delta-query to work

[Rui Pereira]

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