Store Content in IDOL Server > Fields > NumericType Fields

NumericType Fields
You can configure IDOL server to identify fields that contain numerical values. When these fields are indexed, IDOL server stores them in a fast look-up table in memory, so it can quickly return the field. Note that a numeric field can contain a comma-separated list of numbers, each of which is stored as a numeric value for this field, for this document.
 
NOTE A field cannot be configured as NumericType and MatchType concurrently.
To set up NumericType fields to speed numeric queries
1.
2.
List a process that identifies numerical fields in the [FieldProcessing] section. For example:
[FieldProcessing]
0=MyFirstProcess
1=PriceFields
3.
Create a section for each process you listed, and in each section, declare a property for the process (a property is later defined by one or more applicable configuration parameters). Identify the fields you want to associate with the process.
 
NOTE The properties you create must not have the same name as the processes.
For example:
[MyFirstProcess]
Property=MyProperty
PropertyFieldCSVs=*/MyField,*/MyOtherField
[PriceFields]
Property=Price
PropertyFieldCSVs=*/PRICE
4.
Create a section for the property in which you set the NumericType parameter to true. This enables IDOL server to memory map the associated PropertyFieldCSVs fields. For example:
[Price]
NumericType=true
5.
If you now send a query for a specific value that is stored in the PRICE field, IDOL server memory maps the range that this value is in, so it can return results more quickly next time a value that lies in this range is queried.
Examples:
http://12.3.4.56:4000/action=Query&FieldText=NRANGE{50,100}:PRICE
A document's PRICE field must contain a number between 50 and 100 (including decimal numbers) for this document to return.
http://12.3.4.56:4000/action=Query&Text=computer&Sort=PRICE:numberincreasing
The results that IDOL server returns for the query are sorted according to the values their PRICE fields contain. The results whose PRICE field contains the smallest value is listed first, followed by results with increasing values in the PRICE field.