You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by cmd <cm...@hotmail.com> on 2010/08/26 17:26:54 UTC

DIH nested entity and multiple columns

my confile xml like this.
<dataConfig>
<dataSource driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:/temp/example/ex" user="sa" />
    <document name="products">
        <entity name="item" query="select * from item">
            <field column="ID" name="id" />
            <field column="NAME" name="name" />
             ........
            <entity name="feature" query="select col1,col2,col3 from feature
where item_id='${item.ID}'">
                <field name="col1" column="col1" />
                <field name="col2" column="col2" />
                <field name="col3" column="col3" />
            </entity>
        </entity>
    </document>
</dataConfig>

when i query products with some terms 
result can't show feature entity every rows with col1,col2,col3 ,but it is
....
<lst>
<col1>...<col1/>
<col1>...<col1/>
<col1>...<col1/>
</lst>
<lst>
<col2>...<col2/>
<col2>...<col2/>
</lst>
<lst>
<col3>...<col3/>
</lst>

I want to get all fields with item and feature and with nested
entity(document) structure
-- 
View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-entity-and-multiple-columns-tp1354678p1354678.html
Sent from the Solr - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org