Hey all,
I have a query based on a value I'm getting:-
<entity name="id" transformer="RegexTransformer"
query="select * from table">
Where all my fields I want are populated correctly, including the multivalue
one which has the format:
<field column="findID" name="findID" splitBy="," />
But I then want to take the values from 'findID' which are in an array at
the moment:
<arr name="names"><str>10</str><str>12</str></arr>
and submit them to another table to lookup the values, which I do something
like:
<entity name="findid" query="select findID, findName from table2 where
findID = '${id.findID}'">
<field column="findName" name="findName" />
</entity>
Which kinda' works, as I get the first value back, and not the second from
findID.
The field set in the schema is set to multivalue, but not sure what else I
need to do to get all values back into the field.
Any help is appreciated :)
--
View this message in context:
http://lucene.472066.n3.nabble.com/Splitting-data-into-an-array-lookup-tp4019105.html
Sent from the Solr - User mailing list archive at Nabble.com.
