Re: Multivalue wild card search
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?
Re: Multivalue wild card search
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=Namestr[[Hifte, Grop, , ]]/strstr[]/strstr[[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?
Re: Multivalue wild card search
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=Namestr[[Hifte, Grop, , ]]/strstr[]/strstr[[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?
Re: Multivalue wild card search
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=Namestr[[Hifte, Grop, , ]]/strstr[]/strstr[[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?
Re: Multivalue wild card search
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=Namestr[[Hifte, Grop, , ]]/strstr[]/strstr[[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?
Re: Multivalue wild card search
Hi Ethan, With that type standard phrase query should work. If you paste you sample text in analysis page, you will see indexed terms. q=Name:steve wonder should work. You don't need wildcard search in this case. Just do a phrase query. (surrounded with quotes) Ahmet On Tuesday, June 24, 2014 1:07 AM, Ethan eh198...@gmail.com wrote: 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=Namestr[[Hifte, Grop, , ]]/strstr[]/strstr[[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
Re: Multivalue wild card search
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?
Re: Multivalue wild card search
\, \\],[\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?
Re: Multivalue wild card search
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?
Re: Multivalue wild card search
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?
Re: Multivalue wild card search
1. Wildcards do not work within quoted terms. 2. Spaces in terms need to be escaped. 3. The quotes embedded in a term do not need to be escaped. So, try: q=*[Steve,\ Wonder,\ ]] or q=*[Steve,\ Wonder,\ ]* -- Jack Krupansky -Original Message- From: Ethan Sent: Thursday, June 19, 2014 5:16 PM To: solr-user ; Ahmet Arslan Subject: Re: Multivalue wild card search 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?
Re: Multivalue wild card search
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?
Re: Multivalue wild card search
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?
Re: Multivalue wild card search
Wildcard, fuzzy, and regex query do work on multivalued fields, but on only a single value at a time. Your match cannot occur across values. -- Jack Krupansky -Original Message- From: Ethan Sent: Thursday, June 5, 2014 12:52 PM To: solr-user Subject: Re: Multivalue wild card search 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?
Re: Multivalue wild card search
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?
Re: Multivalue wild card search
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?
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?
Re: Multivalue wild card search
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?