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 defined as array type (I can not change its type to string) and contains the following rows: ["Subset 1"] ["Subset 3"] ["Subset 2"] How could I write a range query to get all rows whose category is before ["Subset 2"] alphabetically? I have tried: category:[* TO "Subset 2"] but the row with "Subset 3" could be found in the searching result. Many thanks in advance.
