Hi! I have a typical case where in an attribute (in a DB record) can contain different ranges of numeric values. Let us say the range values in this attribute for "record1" are (20000-40000,5000-8000,45000-50000,454,231,1000). As you can see this attribute can also contain isolated numeric values such as 454, 231 and 1000. Now, I want to return "record1" if the user searches for 20001 or 5003 or 231 or 50000. Right now, I'm exploding the range values (within a transformer) and indexing "record1" for each of the values within a range. But this could result in out-of-memory error if the range is too large. Could you help me figure out a better way of addressing this type of queries using Solr.
Thanks a ton. -- Arun