Jack Thank for your suggestions. I made "initials" a tokenized field and now I'm getting the expected result
On Thu, Feb 28, 2013 at 10:03 AM, Jack Krupansky <j...@basetechnology.com>wrote: > First, what is your unique key field? If it is "id", then only one of > these documents will be stored since they have the same id values. > > Please provide the exact request URL so we can see exactly what the q and > fq parameters look like. Your fq looks malformed, but it's hard to say for > sure without the exact literal URL. > > It appears that your multi-valued "initials" field actually has only a > single value which is a string that contains keywords delimited by blanks. > You have two choices: 1) make "initials" a tokenized/text field, or 2) be > sure to add the second set of initials as a separate value, such as: > "initials":["MKN", "JRT"] > > -- Jack Krupansky > > -----Original Message----- From: Deepak > Sent: Thursday, February 28, 2013 8:05 AM > To: solr-user@lucene.apache.org > Subject: filter query on multi-Valued field > > > Hi How can I filter results using filter query on multi-Valued field. Here > are sample two records { "sub_count":8, > "long_name":"Mike", "first_name":"John", "id":45949, > "sym":"TEST", "type":"T", "last_name":"Account", > "person_id":"3613", "short_name":"Molly", "initials":["ABC > XYZ"], "timestamp":"2013-02-28T02:44:**02.235Z" } { > "sub_count":8, "long_name":"Mike", "first_name":"John", > "id":45949, "sym":"TEST", "type":"T", > "last_name":"Account", "person_id":"3613", > "short_name":"Molly", "initials":["MKN JRT"], > "timestamp":"2013-02-28T02:44:**02.235Z" } Note, all values are same > except initials field value. Solr query criteria q:sym:TEST > fq:initials[MKN] This doesn't return the second record. What am I missing > here? > > > > -- > View this message in context: http://lucene.472066.n3.** > nabble.com/filter-query-on-**multi-Valued-field-tp4043621.**html<http://lucene.472066.n3.nabble.com/filter-query-on-multi-Valued-field-tp4043621.html> > Sent from the Solr - User mailing list archive at Nabble.com. >