Hi Ethan, I understand that you are dealing legacy system.
Can you paste analysis chain used for already indexed docs. I mean xml snippet taken from schema xml. With this, we will figure out how that text is indexed. We will write our query according to that info. Ahmet On Monday, June 23, 2014 10:09 PM, Ethan <eh198...@gmail.com> wrote: 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? > >> >>> > >> >> > >> >> > >> > > >> > >> > > > > >
