On 27 October 2012 01:20, v vijith <vvij...@gmail.com> wrote:
[...]
> The dataconfig file is
> <document>
> <entity name="employee" query="select * from employee">
> <entity name="qualification" query="select * from
> qualification where empid='${employee.EMPID}'"/>
> </entity>
> </document>
[...]
The SELECT in the nested entity "qualification" should fetch
all qualifications for the given employee. How to do that is
database dependent, e.g., one would use something like
group_concat() in mysql. After collecting multiple qualifications
in a single string, one can use a transformer to break the
string at the separator used in group_concat(), and populate
the desired Solr field with the pieces.
Depending on your expertise, it might be easier to do this
through a Solr XML document, or SolrJ.
Regards,
Gora
