The behavior of the range query would depend on how the fieldType used by
the staffName_txt is configured.
I believe you will find that TextField is not the fieldType, but the base
class your fieldType is implemented on.
To use an example from one of the provided example schemas, the "_text"
field is defined as using the "text_general" fieldType
<field name="_text_" type="text_general" indexed="true" stored="false"
multiValued="true"/>
The text_general fieldType is defined as:
<fieldType name="text_general" class="solr.TextField"
positionIncrementGap="100" multiValued="true">
<analyzer type="index">
<tokenizer class="solr.StandardTokenizerFactory"/>
<filter class="solr.StopFilterFactory" ignoreCase="true"
words="stopwords.txt" />
<filter class="solr.LowerCaseFilterFactory"/>
</analyzer>
<analyzer type="query">
<tokenizer class="solr.StandardTokenizerFactory"/>
<filter class="solr.StopFilterFactory" ignoreCase="true"
words="stopwords.txt" />
<filter class="solr.SynonymGraphFilterFactory"
synonyms="synonyms.txt" ignoreCase="true" expand="true"/>
<filter class="solr.LowerCaseFilterFactory"/>
</analyzer>
</fieldType>
This fieldType definition splits the contents of the field into multiple
tokens which each get indexed. So for example "Mr Kenyon John" would
generate 3 tokens: "Mr", "Kenyon" and "John".
If you performed your range query on this field, it would check each token
separately to see if it was in the specified range. If any token was, the
document would be retrieved.
If you want the entire contents of the field to be treated as a single
token, which seems to be your intent, then you should look at using a
fieldType that is based on the Keyword Tokenizer (see
https://solr.apache.org/guide/8_3/tokenizers.html#keyword-tokenizer).
- Andy -
On Fri, Jan 7, 2022 at 12:35 PM WU, Zhiqing <z...@ennov.com> wrote:
> Many thanks for your reply. I have changed my query to
> staffName_txt:["GROSS BOB" TO "LINDMAR DEBORAH"]
> staffName_txt:["gross bob" TO "lindmar deborah"]
> staffName_txt:["Gross Bob" TO "lindmar Deborah"]
> Their "numFound" are identical (177). Apart from "Mr Kenyon John", my
> search result contains " Saab Jerry", which is very confusing.
> Therefore, I think the problem is probably not because of "character case"
>
> On Fri, 7 Jan 2022 at 17:12, Srijan <shree...@gmail.com> wrote:
>
> > My guess is inconsistent "character case" (uppercase/lowercase) in your
> > indexed data vs your search query. For example, I would expect something
> > like staffName_txt:[ "Gross Bob" TO "lindmar Deborah"] to return "Mr
> > Kenyon John" as M indeed does lie between G and l.
> >
> > On Fri, Jan 7, 2022 at 11:10 AM WU, Zhiqing <z...@ennov.com> wrote:
> >
> > > Hello,
> > > I am learning Solr.
> > > In "The Standard Query Parser", I find:
> > > Range queries are not limited to date fields or even numerical fields,
> > but
> > > also use with non-date fields (e.g. title:{Aida TO Carmen})
> > >
> > > I tried a range query in a Solr database (8.3)
> > > staffName_txt:[ "Gross Bob" TO "Lindmar Deborah"]
> > > staffName_txt is defined as a TextField.
> > > Most searched results are correct but "Mr Kenyon John" is also in the
> > > result list.
> > > I think 'M' is after 'L' and should not be included in the result.
> > > May I ask what is wrong in my query? Is there a way to avoid the
> problem?
> > > Many thanks in advance.
> > > Kind regards,
> > > Zhiqing
> > >
> >
>
