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