Just a suggestion .. You can try using dynamic fields by appending the company name (or ID) as prefix ... e.g.
For data - Employee ID Employer FromDate ToDate 21345 IBM 01/01/04 01/01/06 MS 01/01/07 01/01/08 BT 01/01/09 Present Index data as :- Employee ID - 21345 Employer Name - IBM MS BT (Multivalued fields) IBM_FROM_DATE - 01/01/04 (Dynamic field) IBM_TO_DATE - 01/01/06 (Dynamic field) You should be able to match the results and get the from and to date for the companies and handle it on UI side. Regards, Jayendra On Wed, Mar 23, 2011 at 8:24 AM, Sandra <sclo...@consultant.com> wrote: > Hi everyone, > > I know that Solr cannot match 1 value in a multi-valued field with > the corresponding value in another multi-valued field. However my data set > appears to be in that form at the moment. > With that in mind does anyone know of any good articles or > discussions that have addressed this issue, specifically the alternatives > that can be easily done/considered etc.... > > The data is of the following format: > > I have an unique Employee ID field, Employer (multi-value), FromDate > (multi-value) amd ToDate (multi-value). For a given employee ID I am trying > to return the relevent data. For example for a ID of "21345" and emplyer > "IMB" return the work dates from and to. Or for same id and 2 work dates > return the company of companies that the id was associated with etc.... > > > Employee ID Employer FromDate ToDate > 21345 IBM 01/01/04 01/01/06 > MS 01/01/07 01/01/08 > BT 01/01/09 Present > > Any suggestions/comments/ideas/articles much appreciated... > > Thanks, > S. > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Solr-multivalue-fields-please-help-tp2720067p2720067.html > Sent from the Solr - User mailing list archive at Nabble.com. >
