Thanks Jack for quick reply.
Probably my question was not elaborate enough. Let me add more explanation. *Option 1: * Even if I flatten my document to store separate *experiences* in multivalued field, solr will still return me the doc id 1 and 2 if i query : *fq=**experience:Boeing&fq=**experience:Executive* <doc> <str name="id">1</str> <arr name="companyName"> <str>Boeing</str> <str>Kaseya</str> </arr> <arr name="positionName"> <str>Executive</str> <str>Technician</str> </arr> <arr name="experience"> <str>Boeing, Executive</str> <str>Kaseya, Technician</str> </arr> <doc> <doc> <str name="id">2</str> <arr name="companyName"> <str>Boeing</str> <str>Kodak</str> </arr> <arr name="positionName"> <str>Technician</str> <str>Executive</str> </arr> <arr name="experience"> <str>Boeing, Technician</str> <str>Kodak, Executive</str> </arr> <doc> *Option 2: * Storing separate experience in separate fields and generate query q=(exp1:(Boeing AND Executive) OR exp2:(Boeing AND Executive)) and this can be queried to return the docs with the expected match. <doc> <str name="id">2</str> ... <str name="exp1">Boeing, Executive</str> <str name="exp2">Kodak, Executive</str> <doc> * * Please suggest. * * I would just love to know how linkedin does it to show facets for people working in company with titles. Thanks On Sat, Sep 28, 2013 at 9:58 PM, Jack Krupansky <j...@basetechnology.com>wrote: > "multivalued fields maintained in order" > > That is not a feature supported by Solr. > > Solr will maintain the order of an individual multivalued field and will > return the values of that field in order, but makes no other use of the > order. > > Ditto for "corresponding multivalued fields". Solr does not support any > correspondence between multivalued fields. > > You must flatten your data your data to achieve any correspondence. > > Multivalued field are a powerful feature of Solr, but you must be > extremely careful to use them only in moderation. > > -- Jack Krupansky > > -----Original Message----- From: Rohit Kumar > Sent: Saturday, September 28, 2013 12:11 PM > To: solr-user@lucene.apache.org > Subject: Section Search in SOLR > > > Hi, > > I have following SOLR documents indexed. > > <doc> > <str name="id">1</str> > <arr name="companyName"> > <str>Boeing</str> > <str>Kaseya</str> > </arr> > <arr name="positionName"> > <str>Executive</str> > <str>Technician</str> > </arr> > <doc> > > <doc> > <str name="id">2</str> > <arr name="companyName"> > <str>Boeing</str> > <str>Kodak</str> > </arr> > <arr name="positionName"> > <str>Technician</str> > <str>Executive</str> > </arr> > <doc> > > > Company name and Position name are multivalued fields maintained in order. > > The following is the solr query. > *fq=companyName:Boeing&fq=**positionName:Executive* which returns both the > > documents as expected. > What changes will i have to make to be able to search for > companyName:Boeing and positionName:Executive both at same indexes in the > corresponding multivalued fields i.e. should return me only doc id 1. > > > Thanks, > Rohit Kumar >