Re: Solr list operator

2017-09-15 Thread Shawn Heisey
On 9/12/2017 7:21 AM, Nick Way wrote: > Thank you very much Erik, Walter and Susheel. > > To be honest I didn't really understand the suggested routes (due to my > limited knowledge) but managed to get things working by inserting my data > with a double comma at the beginning eg: > > custom field "

Re: Solr list operator

2017-09-12 Thread Walter Underwood
That is not the way to do it. It is slow and will not scale. Wildcards are usually not a good idea in Solr. The simplest way is to search for the numbers as words. Index the string “1 2 4 33”. Search for one of those words, like listOfIDs:4. It is better to index the numbers as an array, but I

Re: Solr list operator

2017-09-12 Thread Nick Way
Thank you very much Erik, Walter and Susheel. To be honest I didn't really understand the suggested routes (due to my limited knowledge) but managed to get things working by inserting my data with a double comma at the beginning eg: custom field "listOfIDs" = ",,1,2,4,33" and then searching for

Re: Solr list operator

2017-09-06 Thread Erick Erickson
You'll have to split up the input on commas if you don't just do it the multiValued way Walter suggests, perhaps one of the pattern tokenizers mentioned here: https://cwiki.apache.org/confluence/display/solr/Tokenizers Best, Erick On Wed, Sep 6, 2017 at 6:29 AM, Walter Underwood wrote: > Use a

Re: Solr list operator

2017-09-06 Thread Walter Underwood
Use a multivalued field. Search for listOfIds:1. Or search for listOfIds:33. This is one of the simplest things that Solr can do. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) > On Sep 6, 2017, at 6:07 AM, Susheel Kumar wrote: > > Nick, checkout term

Re: Solr list operator

2017-09-06 Thread Susheel Kumar
Nick, checkout terms query parser http://lucene.apache.org/solr/guide/6_6/other-parsers.html or streaming expressions. Thnx On Wed, Sep 6, 2017 at 8:33 AM, alex goretoy wrote: > https://www.youtube.com/watch?v=pNe1wWeaHOU&list= > PLYI8318YYdkCsZ7dsYV01n6TZhXA6Wf9i&index=1 > https://www.youtube.

Re: Solr list operator

2017-09-06 Thread alex goretoy
https://www.youtube.com/watch?v=pNe1wWeaHOU&list=PLYI8318YYdkCsZ7dsYV01n6TZhXA6Wf9i&index=1 https://www.youtube.com/watch?v=pNe1wWeaHOU&list=PLYI8318YYdkCsZ7dsYV01n6TZhXA6Wf9i&index=1 http://audiobible.life CHECK IT OUT! On Wed, Sep 6, 2017 at 5:57 PM, Nick Way wrote: > Hi, I have a custom fiel

Solr list operator

2017-09-06 Thread Nick Way
Hi, I have a custom field "listOfIDs" = "1,2,4,33" I want the equivalent of: select * where '1' IN (listOfIDs) --> should get a match select * where '33' IN (listOfIDs) --> should get a match select * where '3' IN (listOfIDs) --> should NOT get a match Can anyone help me out please as I ca