Hi Alberto,
You can add child entity which returns multiple records, i.e.
<entity name="root" query="select id, title from titles">
<entity name="child" query="select value from multivalued where
title_id='${root.id}'">
</entity>
</entity>
HTH,
Alex
2010/6/7 Alberto García Sola <alberto...@gmail.com>:
> Hello, this is my first message to this list.
>
> I was wondering if it is possible to use multiValued when using MySQL (or
> any SQL-database engine) through DataImportHandler.
>
> I've tried using a query which return something like this:
> 1 - title1 - multivalue1-1
> 1 - title1 - multivalue1-2
> 1 - title1 - multivalue1-3
> 2 - title2 - multivalue2-1
> 2 - title2 - multivalue2-2
>
> And using the first row as ID. But that only returns me the first occurrence
> rather than transforming them into multiValued fields.
>
> Is there a way to deal with multiValued in databases?
>
> NOTE: The way of working with multivalues I use is using foreign keys and
> relate them into the query so that the query gives me the results the way I
> have shown.
>
> Regards,
> Alberto.
>
