Solr - DeltaImport doenst run the parentDeltaQuery
- by rails
I have 1:n relation between my main entity(PackageVersion) and its tag in my DB.
I add a new tag with this date to the db at the timestamp and I run delta import command.
the select retrieves the line but i dont see any other sql.
Here are my data-config.xml configurations:
<entity name="PackageVersion" pk="PackageVersionId" 
        query=  "select ...
                from [dbo].[Package] Package inner join [dbo].[PackageVersion] PackageVersion on Package.Id = PackageVersion.PackageId" 
        deltaQuery = "select PackageVersion.Id PackageVersionId
                      from [dbo].[Package] Package inner join [dbo].[PackageVersion] PackageVersion on Package.Id = PackageVersion.PackageId
                      where Package.LastModificationTime > '${dataimporter.last_index_time}' OR PackageVersion.Timestamp > '${dataimporter.last_index_time}'" 
        deltaImportQuery="select ... 
                          from [dbo].[Package] Package inner join [dbo].[PackageVersion] PackageVersion on Package.Id = PackageVersion.PackageId
                          Where PackageVersionId=='${dih.delta.id}'" >
                <entity name="PackageTag" pk="ResourceId"  processor="CachedSqlEntityProcessor" cacheKey="ResourceId" cacheLookup="PackageVersion.PackageId"
                        query=  "SELECT ResourceId,[Text] PackageTag 
                                 from [dbo].[Tag] Tag"
                        deltaQuery="SELECT ResourceId,[Text] PackageTag 
                                    from [dbo].[Tag] Tag
                                    Where Tag.TimeStamp > '${dataimporter.last_index_time}'"
                        parentDeltaQuery="select PackageVersion.PackageVersionId
                                    from [dbo].[Package]
                                    where Package.Id=${PackageTag.ResourceId}">
                </entity>
</entity>