You need to do several things to track down why. First, use something (admin UI, terms query, etc) to see exactly what’s in your index. The admin/analysis screen is useful here.
Second, aldd &debug=query to the query on both machines and see what the actual parsed query looks like. Comparing those should give you a clue. Best, Erick > On Jun 24, 2020, at 9:20 AM, yaswanth kumar <yaswanth...@gmail.com> wrote: > > "nsallschools":["BostonSchool"] > > That's how the data is stored against the field. > > We have a functionality where we can do "Starts with, Contains, Ends with"; > Also if you look at the above schema we are using > > <filter class="solr.SynonymFilterFactory" > synonyms="punctuation-whitelist.txt" ignoreCase="true" expand="false"/> > <tokenizer class="solr.KeywordTokenizerFactory"/> > <filter class="solr.LowerCaseFilterFactory"/> > <filter class="solr.ASCIIFoldingFilterFactory"/> > > Also the strange part is that its working fine in Solr 5.5 but not in Solr > 8.2 any thoughts?? > > Thanks, > > On Wed, Jun 24, 2020 at 3:15 AM Jörn Franke <jornfra...@gmail.com> wrote: > >> I don’t know your data, but could it be that you tokenize differently ? >> >> Why do you do the wildcard search at all? Maybe a different tokenizing >> strategy can bring you more effieciently results? Depends on what you need >> to achieve of course ... >> >>> Am 24.06.2020 um 05:37 schrieb yaswanth kumar <yaswanth...@gmail.com>: >>> >>> I am using solr 8.2 >>> >>> And when trying to do fq=auto_nsallschools:*bostonschool*, the data is >> not >>> being returned. But if I do the same in solr 5.5 (which I already have >> and >>> we are in process of migrating to 8.2 ) its returning results. >>> >>> if I do fq=auto_nsallschools:bostonschool >>> or >>> fq=auto_nsallschools:bostonschool* its returning results but when I try >>> with contains like described above or fq=auto_nsallschools:*bostonschool >>> (ends with) it's not returning any results. >>> >>> The field which we are already using is a copy field and multi valued, >> am I >>> doing something wrong? or does 8.2 need some adjustment in the configs? >>> >>> Here is the schema >>> >>> <field name="nsallschools" type="txtStandard" indexed="true" >> stored="true" >>> multiValued="true"/> >>> <field name="auto_nsallschools" type="nstxtLowerCaseMatch" indexed="true" >>> stored="false" multiValued="true"/> >>> <copyField source="nsallschools" dest="auto_nsallschools" /> >>> >>> >>> <fieldType name="txtStandard" class="solr.TextField" >>> positionIncrementGap="100"> >>> <analyzer> >>> <tokenizer class="solr.StandardTokenizerFactory"/> >>> <filter class="solr.LowerCaseFilterFactory"/> >>> <filter class="solr.ASCIIFoldingFilterFactory"/> >>> </analyzer> >>> </fieldType> >>> >>> >>> <fieldType name="nstxtLowerCaseMatch" class="solr.TextField" >>> positionIncrementGap="100"> >>> <analyzer> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\&)" replacement="_and_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\$)" replacement="_dollar_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\*)" replacement="_star_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\+)" replacement="_plus_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\-)" replacement="_minus_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\#)" replacement="_sharp_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\%)" replacement="_percent_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\=)" replacement="_equal_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\<)" replacement="_lessthan_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\>)" replacement="_greaterthan_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\€)" replacement="_euro_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\¢)" replacement="_cent_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\£)" replacement="_pound_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\¥)" replacement="_yuan_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\©)" replacement="_copyright_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\®)" replacement="_registered_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\|)" replacement="_pipe_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\^)" replacement="_caret_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\~)" replacement="_tilt_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\™)" replacement="_treadmark_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\@)" replacement="_at_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\")" replacement=" _doublequote_ " /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\()" replacement=" _leftparentheses_ " /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\))" replacement=" _rightparentheses_ " /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\{)" replacement="_leftcurlybracket_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\})" replacement="_rightcurlybracket_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\[)" replacement="_leftsquarebracket_" /> >>> <charFilter class="solr.PatternReplaceCharFilterFactory" >>> pattern="(\])" replacement="_rightsquarebracket_" /> >>> <filter class="solr.SynonymFilterFactory" >>> synonyms="punctuation-whitelist.txt" ignoreCase="true" expand="false"/> >>> <tokenizer class="solr.KeywordTokenizerFactory"/> >>> <filter class="solr.LowerCaseFilterFactory"/> >>> <filter class="solr.ASCIIFoldingFilterFactory"/> >>> </analyzer> >>> </fieldType> >>> >>> Thanks, >>> >>> -- >>> Thanks & Regards, >>> Yaswanth Kumar Konathala. >>> yaswanth...@gmail.com >> > > > -- > Thanks & Regards, > Yaswanth Kumar Konathala. > yaswanth...@gmail.com