You can configure HPE IDOL Server to identify fields that contain dates. When these fields are indexed, HPE IDOL Server stores them in a fast look-up table in memory, so that it can quickly return the fields.
You cannot configure a field with two numeric-based types concurrently. Numeric-based types include NumericType
, NumericDateType
, MatchType
, ParametricRangeType
, ReferenceMemoryMappedType
, and ParametricType
when the ParametricNumericMapping
configuration parameter is set to True
.
HPE IDOL Server converts dates to numerical values (epoch seconds) and identifies the fields that contain the numerical date values.
Open the HPE IDOL Server configuration file in a text editor.
List a process that identifies numeric date fields in the [FieldProcessing]
section. For example:
[FieldProcessing] 0=MyFirstProcess 1=NumericDateFields
Create a section for each process that you listed, and in each section, create a property for the process (you define the property by setting one or more applicable configuration parameters). Identify the fields that you want to associate with the process.
The properties that you create must not have the same name as the processes.
For example:
[MyFirstProcess] Property=MyProperty PropertyFieldCSVs=*/MyField,*/MyOtherField [NumericDateFields] Property=NumDate PropertyFieldCSVs=*/BIRTHDAY,*/STARTDATE
Create a section for the property in which you set the NumericDateType
parameter to True
. This enables HPE IDOL Server to memory map the associated PropertyFieldCSVs
fields, and identify them as fields that contain date values. For example:
[NumDate] NumericDateType=True
Save and close the configuration file. Restart HPE IDOL Server for your changes to take effect.
If you now send a query for a specific value that is stored in the BIRTHDAY
field, HPE IDOL Server memory maps the range that this value is in, so that it can return results more quickly next time a value that lies in this range is queried.
For example:
http://12.3.4.56:4000/action=Query&FieldText=RANGE{01/01/1980,31/12/1980}:BIRTHDAY
The BIRTHDAY
field must contain a numeric date value that is between 01/01/1980 and 31/12/1980 for this document to be returned.
|