Hey Ahmet, Yes, brackets, commas and quotes are part of fields value. It's something I inherited and working on improving it.
The field is of type solr.TextField. Adding StandardTokenizer solves the problem for the new documents. It doesn't work on already indexed docs. Is there a solution for that other than re-indexing? Thanks, E On Mon, Jun 23, 2014 at 11:05 AM, Ahmet Arslan <iori...@yahoo.com.invalid> wrote: > > Hi Ethan, > > XML response is helpful, so you still have brackets, commas, quotes in > field value? > > What is the field type you use for Name field? > > If you tokenize it StandardTokenizer simple phrase query would do the trick > q=Name:"Steve Wonder" > > Also consider cleaning up your values. Why would you store all that > brackets etc? > > > Ahmet > > > On Monday, June 23, 2014 7:45 PM, Ethan <eh198...@gmail.com> wrote: > > > > Ahmet, > Yes, they were part of JSON output, Here is the xml response > > <arr name="Name"><str>[["Hifte", "Grop", "", > ""]]</str><str>[]</str><str>[["Ethan", "G", "", ""],["Steve", "Wonder", "", > ""]]</str></arr> > > > I solution suggested by Jack to look up Steve Wonder doesn't work as > asterick is replaced by the defaultsearch field. Any suggestions? > > Thanks, > E > > > > On Fri, Jun 20, 2014 at 12:40 AM, Ahmet Arslan <iori...@yahoo.com.invalid> > wrote: > > Hi, > > > >What are these square brackets, back slashes, quotes? > >Are they part of JSON output? Can you paste human reman able XML response > writer output? > > > >Thanks, > >Ahmet > > > > > > > > > >On Friday, June 20, 2014 12:17 AM, Ethan <eh198...@gmail.com> wrote: > >Ahmet, > > > >Assuming there is a multiValued field called "Name" of type string stored > >in index - > > > >//Doc 1 > >"id" : 23512 > >"HotelId" : [ > > "12", > > "23", > > "12" > >] > >"Name" : [ > >"[[\"Ethan\", \"G\", \"\"],[\"Steve\", \"Wonder\", \"\"]]", > >"[]", > >"[[\"hifte\", \"Grop\", \"\"]]" > >] > > > >// Doc 2 > > > >"id" : 23513 > >"HotelId" : [ > > "12", > > "12" > >] > >"Name" : [ > >"[[\"Ethan\", \"G\", \"\"],[\"Steve\", \"\", \"\"]]", > >"[]", > >] > > > >Here, how do I find the document with Name that contains "Steve Wonder"? > > > >I tried q="***[\"Steve\", \"Wonder\", \"\"]]" but that doesn't work. > > > > > > > > > > > >On Fri, Jun 6, 2014 at 11:10 AM, Ahmet Arslan <iori...@yahoo.com.invalid> > >wrote: > > > >> Hi Ethan, > >> > >> > >> It is hard to understand your example. Can you re-write it? Using xml? > >> > >> > >> > >> On Friday, June 6, 2014 9:07 PM, Ethan <eh198...@gmail.com> wrote: > >> Bumping the thread to see if anyone has a solution. > >> > >> > >> > >> > >> > >> On Thu, Jun 5, 2014 at 9:52 AM, Ethan <eh198...@gmail.com> wrote: > >> > >> > Wildcard search do work on multiValued field. I was able to pull up > >> > records for following multiValued field - > >> > > >> > Code : [ > >> > "12344", > >> > "4534", > >> > "674" > >> > ] > >> > > >> > q=Code:45* fetched the correct document. It doesn't work in > >> > quotes(q="Code:45*"), however. Is there a workaround? > >> > > >> > > >> > On Thu, Jun 5, 2014 at 9:34 AM, Ethan <eh198...@gmail.com> wrote: > >> > > >> >> Are you implying there is not way to lookup on a multiValued field > with > >> a > >> >> substring? If so, then how is it usually handled? > >> >> > >> >> > >> >> On Wed, Jun 4, 2014 at 4:44 PM, Jack Krupansky < > j...@basetechnology.com > >> > > >> >> wrote: > >> >> > >> >>> Wildcard, fuzzy, and regex query operate on a single term of a > single > >> >>> tokenized field value or a single string field value. > >> >>> > >> >>> -- Jack Krupansky > >> >>> > >> >>> -----Original Message----- From: Ethan > >> >>> Sent: Wednesday, June 4, 2014 6:59 PM > >> >>> To: solr-user > >> >>> Subject: Multivalue wild card search > >> >>> > >> >>> > >> >>> I can't seem to find a solution to do wild card search on a > multiValued > >> >>> field. > >> >>> > >> >>> For Eg consider a multiValued field called "Name" with 3 values - > >> >>> > >> >>> "Name" : [ > >> >>> "[[\"Ethan\", \"G\", \"\"],[\"Steve\", \"Wonder\", \"\"]]", > >> >>> "[]", > >> >>> "[[\"hifte\", \"Grop\", \"\"]]" > >> >>> ] > >> >>> > >> >>> For a multiValued like above, I want search like- > >> >>> > >> >>> q="***[\"Steve\", \"Wonder\", \"\"]" > >> >>> > >> >>> > >> >>> But I do not get back any results back. Any ideas on to create such > >> >>> query? > >> >>> > >> >> > >> >> > >> > > >> > >> > > > > >
