Solr - DeltaImport doenst run the parentDeltaQuery

Posted by rails on Stack Overflow See other posts from Stack Overflow or by rails
Published on 2013-07-02T10:48:55Z Indexed on 2013/07/02 11:05 UTC
Read the original article Hit count: 187

Filed under:
|

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>

© Stack Overflow or respective owner

Related posts about search

Related posts about solr