Ahmet,

Here the xml for the field "Name" - Let me know if I need to update it.

 <field name="Name" type="token2" indexed="true" stored="true"
multiValued="true" omitTermFreqAndPositions="false"/>

 <types>
  <fieldType name="token2" class="solr.TextField" omitNorms="true"
positionIncrementGap="1">
        <analyzer>
            <tokenizer class="solr.StandardTokenizerFactory"/>
            <filter class="solr.LowerCaseFilterFactory"/>
        </analyzer>
    </fieldType>
 </types>

Thanks,
E


On Mon, Jun 23, 2014 at 12:38 PM, Ahmet Arslan <iori...@yahoo.com.invalid>
wrote:

> 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?
> > >> >>>
> > >> >>
> > >> >>
> > >> >
> > >>
> > >>
> > >
> > >
> >
>
>

Reply via email to