You can configure the IDOL Content component to identify fields that contain dates. When these fields are indexed, Content stores them in a fast look-up table in memory, so that it can quickly return the fields.
NOTE: 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
.
Content converts dates to numerical values (epoch seconds) and identifies the fields that contain the numerical date values.
Open the IDOL Content component 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.
NOTE: 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 Content 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 the IDOL Content component for your changes to take effect.
If you now send a query for a specific value that is stored in the BIRTHDAY
field, Content 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.