Could I do a range query for an array type column?

2022-01-07 Thread WU, Zhiqing
Hello, May I ask if I could do a range query for an array type column? For number type column, the following range query works in Solr: product_id:[ 1 TO 100] For string type column, the following range query works as well: product_name: [ * TO "Television"] If a column, say “category” has been

Range query on TextField

2022-01-07 Thread WU, Zhiqing
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"]

Re: Range query on TextField

2022-01-07 Thread WU, Zhiqing
aracter 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. > >

Re: Range query on TextField

2022-01-12 Thread WU, Zhiqing
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 > do

Re: Range query on TextField

2022-01-12 Thread WU, Zhiqing
> > modifying the text_general fieldType, and explicitly map the > staffName_txt > > field to it. Otherwise you will change how searching works for all fields > > that use this the text_general fieldType (you would no longer be able to > > retrieve documents by searching for

Why I could not add "type"="....." after analyzer in managed-schema?

2022-01-14 Thread WU, Zhiqing
Hello, I am trying to create a field type in managed-schema (Solr 8.11). The data post to solr is: { "add-field-type": { "name": "myNewTxtField", "class": "solr.TextField", "analyzer": { "type": "query", "tokenizer": { "class": "so

Can I insert query result into another collection of the same Solr?

2022-03-23 Thread WU, Zhiqing
Hello, I did a query based on one collection and want to insert its result into another collection of the same Solr. The query result has the same fields as that of another collection. Is there a simple way to do the job? If the query result has to be moved outside Solr before being added to anothe

Re: Can I insert query result into another collection of the same Solr?

2022-03-23 Thread WU, Zhiqing
e.org/guide/8_4/stream-decorator-reference.html > > Sent from my iPhone > > > On Mar 23, 2022, at 4:06 AM, WU, Zhiqing wrote: > > > > Hello, > > I did a query based on one collection and want to insert its result into > > another collection of the same Sol

Nested Facets and SortableTextField

2022-04-25 Thread WU, Zhiqing
Hello, I do not know why Nested Facets ( https://solr.apache.org/guide/8_11/json-facet-api.html#nested-facets) does not work for _txt_sort field (SortableTextField). To reproduce the problem, I created a new collection (Config set: _default) and add the following to the collection { "name_txt_

Re: Nested Facets and SortableTextField

2022-04-25 Thread WU, Zhiqing
":"Olivia Wilson", "count":1}]}}} Should I try "method":"uif" at another place? Kind regards, Zhiqing On Mon, 25 Apr 2022 at 17:47, Michael Gibney wrote: > This is related to https://issues.apache.org/jira/browse/SOLR-13056 > >

Re: Nested Facets and SortableTextField

2022-04-27 Thread WU, Zhiqing
recommendation is: don't use SortableTextField for faceting. > Would it work to use TextField instead? TextField has to be uninverted, but > at least it meets the requirement of indexed values being compatible with > values over which bulk facet collection takes place. > > O

Why OR in query does not work sometimes?

2022-05-16 Thread WU, Zhiqing
Hello, What is wrong with my following query? I have a Solr query: { "query": X, "sort":"prodAllGeneric_txt_sort asc" } (Note: prodAllGeneric_txt_sort is a field, X is the details of a query) If X is "(prodAllGeneric_txt_sort:\"Phi; \")", Solr finds 3 documents If X is "(-prodAllGeneric_txt_s

Re: Why OR in query does not work sometimes?

2022-05-17 Thread WU, Zhiqing
Thank Shawn and Tim, The following line addresses my issue. > prodAllGeneric_txt_sort:"Phi; " OR (*:* -prodAllGeneric_txt_sort:[* TO *]) Besides, your explanation is very helpful. Kind regards, Zhiqing On Tue, 17 May 2022 at 02:45, Shawn Heisey wrote: > On 5/16/2022 2:32 PM, W

Re: Nested Facets and SortableTextField

2022-05-17 Thread WU, Zhiqing
other more narrow solution?), I think the > only > > > responsible recommendation is: don't use SortableTextField for > faceting. > > > Would it work to use TextField instead? TextField has to be uninverted, > > but > > > at least it meets the req

How to select the class of fields

2022-05-17 Thread WU, Zhiqing
Hello, We are going to change the class of key fields in our Solr. We hope these fields are sortable and can be used for grouping and searching. We have considered solr.StrField, TextField and SortableTextField. However, we notice that StrField is not case-insensitive, which is not good for searchi

Re: How to select the class of fields

2022-05-18 Thread WU, Zhiqing
e indexed in different > fields with different analyses. If you do it with copyField, you don't even > have to worry about it at index time. > > Thomas > > Op di 17 mei 2022 om 22:21 schreef WU, Zhiqing : > > > Hello, > > We are going to change the class of k

How could I get the bucket (or group) which value of the grouping field is null by using Facet API?

2022-05-24 Thread WU, Zhiqing
Hello, I use two methods to get the information of groups, one is Result Grouping and the other is Terms Facet. Result grouping: q=*:*&group=true&group.field=repPatSurname_s&rows=100 Terms Facet { "query": "*:*", "limit":0, "facet": { "categories" : { "type": "terms", "field"

Re: How could I get the bucket (or group) which value of the grouping field is null by using Facet API?

2022-07-29 Thread WU, Zhiqing
Yes, the "missing" parameter is what I was looking for. Many thanks, Zhiqing On Tue, 24 May 2022 at 21:28, Shawn Heisey wrote: > On 5/24/22 13:48, WU, Zhiqing wrote: > > Is there any setting in Facet API I could change to get the 'field = > null' > &g

numBuckets is not correct.

2022-07-29 Thread WU, Zhiqing
Hello, I tried to get numBuckets of a facet but "numBuckets" shown in the Solr response is wrong. My query to Solr (8.11): { "query": "caseRef_txt_sort:*009*", "limit": 0, "fields": ["caseno_s"], "facet": { "categories": { "field": "caseno_s", "offset": 0, "limit": -1