search by multiple 'LIKE' operator connected with 'AND' operator
Hi. I have a trouble with SOLR configuration. Just want to implement configuration that would be operate with index like MySQL query: field_name LIKE '%foo%' AND field_name LIKE '%bar%'. So, for example, I have 4 indexed titles: 'Kathy Lee', 'Kathy Norris', 'Kathy Davies', 'Kathy Bird' and with my query Kathy Norris I receive all these indexes. Quoted query give no results at all. latest field definition that I've try (very simple, just for tests): Also I've try field with ShingleFilterFactory, also ShingleFilterFactory combined with NGrams. But no results. Btw. I have default solr configuration for drupal search_api_solr module, just modified with a new request handler. Trying different configurations not give expected results. Thanks for help. -- View this message in context: http://lucene.472066.n3.nabble.com/search-by-multiple-LIKE-operator-connected-with-AND-operator-tp4012536.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: search by multiple 'LIKE' operator connected with 'AND' operator
Disabling PositionFilterFactory is totally break multiword search, and I could find titles only by single word. Default solr.TextField field with WhitespaceTokenizerFactory returns only complete words match, enabling NGramFilterFactory for that field doesn't do anything for me. If I use field described I coud find by both words, but no 'both at a time', just 'one of any'. TextField field copied by copyField into NGram field also doesn't helps. Maybe I miss something from schema configuration? -- View this message in context: http://lucene.472066.n3.nabble.com/search-by-multiple-LIKE-operator-connected-with-AND-operator-tp4012536p4012554.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: search by multiple 'LIKE' operator connected with 'AND' operator
I'm also unable to config that type of search through schema.xml. As I use SOLR in drupal, I've implement that in hook_search_api_solr_query_alter by exploding my search string on two (or more) chunks and now search works well. Strangely that couldn'y do it through SOLR configuration. -- View this message in context: http://lucene.472066.n3.nabble.com/search-by-multiple-LIKE-operator-connected-with-AND-operator-tp4012536p4012861.html Sent from the Solr - User mailing list archive at Nabble.com.