The PositionFilterFactory is probably preventing phrase queries from
working. What are you expecting it to do? It basically means query if all
the quoted terms occur at the same position.
SQL "like" is comparable to Lucene wildcard, but change the "%" to "*" and
"_" to "?".
-- Jack Krupansky
-----Original Message-----
From: gremlin
Sent: Monday, October 08, 2012 10:47 AM
To: solr-user@lucene.apache.org
Subject: 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):
<fieldType name="text_ngram" class="solr.TextField" indexed="true"
stored="true" multiValued="true" positionIncrementGap="100"
autoGeneratePhraseQueries="false" >
<analyzer type="index">
<tokenizer class="solr.WhitespaceTokenizerFactory"/>
<filter class="solr.LowerCaseFilterFactory"/>
<filter class="solr.NGramFilterFactory" minGramSize="2"
maxGramSize="100"/>
</analyzer>
<analyzer type="query">
<tokenizer class="solr.WhitespaceTokenizerFactory"/>
<filter class="solr.LowerCaseFilterFactory"/>
<filter class="solr.PositionFilterFactory" />
</analyzer>
</fieldType>
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.