Hi All,

I am trying to index nested document. While start full data-import (from UI) 
following options selected Verbose, Commit, Debug & Debug-Mode.

Raw Debug-Response shows that "child" entity query execute repeatedly. Kindly 
help me to understand this, how can I resolve this, am I missed anything?

Sample data-config.xml
<document name="companies">
                                <entity name="company" 
transformer="RegexTransformer" rootEntity="true"
                                query="SELECT * FROM COMPANY">
                                                <field column="ID" name="c_id"/>
                                                <field column="DEPARTMENT" 
name="c_department"/>

                                                <entity name="employee" 
child="true"
                                                query="SELECT * FROM EMPLOYEE
                                                WHERE com_employee_id = 
'${company.ID}'">
                                                                <field 
column="NAME" name="e_name"/>
                                                                <field 
column="EXPERIENCE" name="e_experience"/>
                                                </entity>
                                </entity>
</document>
------------------------------------------------------------------------------------------------------------------------------------
Raw Debug-Response:

"entity:company",
[
    "document#1",
    [
        "query",
        "SELECT * FROM COMPANY",

       "----------------------------------------",
        "transformer:RegexTransformer",
        [
          "entity:employee",
[
            "query",
            "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
                ]
        ]
    ],
"document#2",
    [
        "transformer:RegexTransformer",
        [
          "entity:employee",
          [
            "query",
            "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
            "query",
            "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
                ]
          ]
     ]
]

"document#3"
                "entity:employee",
                "query",
                "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
"query",
"SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
                "query",
                "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'"


Thanks,
Prabaharan

Reply via email to