I'ev had a chance to play with this more and noticed the query does run fine
but it only updates the records that are already indexed it doesn't add new
ones.
The only option that i'ev found so far is to do a full-import with the
"clean=false" attribute and created_date > last_indexed_date...
Is there a better way?
Thanks
Noble Paul നോബിള് नोब्ळ् wrote:
>
> I do not observe anything wrong.
>
> you can also mention the 'deltaImportQuery' and try it
>
> someting like
>
> <entity name="table1" pk="id"
> query=" SELECT ID,MY_GUID
> FROM activityLog
> WHERE type in (11, 15)"
> deltaImportQuery="SELECT ID,MY_GUID
> FROM activityLog
> WHERE type in (11, 15) AND
> id=${dataimporter.delta.ID}"
> deltaQuery="SELECT ID,MY_GUID
> FROM activityLog
> WHERE type in (11, 15) and created_date >
> '${dataimporter.last_index_time}'">
>
>
>
> On Tue, Dec 16, 2008 at 5:54 AM, sbutalia <sbuta...@gmail.com> wrote:
>>
>> I have a parent entity that grabs a list of records of a certain type
>> from 1
>> table... and a sub-entity that queries another table to retrieve the
>> actual
>> data... for various reasons I cannot join the tables... the 2nd sql query
>> converts the rows into an xml to be processed by a custom transformer
>> (done
>> due to the complex nature of the second table)
>>
>> Full-import works fine but delta-import is not adding any new records...
>>
>> Do I have to specify a deltaQuery for the sub-entity? What else might be
>> goin on?
>>
>> <document name="doc">
>> <entity name="table1" pk="id"
>> query=" SELECT ID,MY_GUID
>> FROM activityLog
>> WHERE type in (11, 15)"
>> deltaQuery="
>> SELECT ID,MY_GUID
>> FROM activityLog
>> WHERE type in (11, 15) and created_date >
>> '${dataimporter.last_index_time}'">
>> <field column="MY_GUID" name="myGuid"/>
>> <entity name="table2" pk="ID"
>> query="select dbms_xmlgen.getxml('
>> select Name,
>> Title, Description
>> from
>> metaDataTable
>> where MY_GUID =
>> ${table1.MY_GUID_ID}
>> ') mdrXmlClob
>> from dual
>> "
>>
>> transformer="MD.Solr.Utils.transformers.MDTransformer">
>> <field column="Name" name="mdName"/>
>> <field column="Title" name="mdTitle"/>
>> <field column="Description"
>> name="mdDescription"/>
>> </entity>
>> </entity>
>> </document>
>> --
>> View this message in context:
>> http://www.nabble.com/Parent-Child-Entity---DataImport-tp21024979p21024979.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> --Noble Paul
>
>
--
View this message in context:
http://www.nabble.com/Parent-Child-Entity---DataImport-tp21024979p21027045.html
Sent from the Solr - User mailing list archive at Nabble.com.
