lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MitchK <mitc...@web.de>
Subject Short Question: Fills this entity multiValued Fields (DIH)?
Date Wed, 07 Apr 2010 15:35:20 GMT

Hello all,

I read through the wiki to find a solution on filling multiValued fields
with, you guessed it, multiple values. :)

What I have found was a short excerpt of code and I am not really sure,
whether this fills a multiValued-field with multiple values. 
The code (not everything is relevant, but maybe it is of any interrest):

<document name="products">
        <entity name="item" query="select * from item">
            <field column="ID" name="id" />
            <field column="NAME" name="name" />
            <field column="MANU" name="manu" />
            <field column="WEIGHT" name="weight" />
            <field column="PRICE" name="price" />
            <field column="POPULARITY" name="popularity" />
            <field column="INSTOCK" name="inStock" />
            <field column="INCLUDES" name="includes" />

            <entity name="feature" query="select description from feature
where item_id='${item.ID}'">
                <field name="features" column="description" />
            </entity>
            <entity name="item_category" query="select CATEGORY_ID from
item_category where item_id='${item.ID}'">
                <entity name="category" query="select description from
category where id = '${item_category.CATEGORY_ID}'">
                    <field column="description" name="cat" />
                </entity>
            </entity>
        </entity>
    </document>
----------------------------------------


Have a look at these two lines:
----------------------------------------
<entity name="feature" query="select description from feature where
item_id='${item.ID}'">
                <field name="features" column="description" />
----------------------------------------

If there is more than one description per item_ID, does the features-field
gets multiple values if it is defined as multiValued=true?

If not, how do I create multiValued fields from RDBMS?

Thank you in advance!
- Mitch
-- 
View this message in context: http://n3.nabble.com/Short-Question-Fills-this-entity-multiValued-Fields-DIH-tp703245p703245.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message