OneData 10.7 | Managing Master Data with webMethods OneData | Administering webMethods OneData | Working with In-Memory and Caching in OneData | In-Memory Database | Configuration for Null Value Filtering in Terracotta Cache
 
Configuration for Null Value Filtering in Terracotta Cache
For data filtering, OneData uses the indexing functionality in Terracotta. To support indexing of null values in Terracotta, OneData provides substitutes for the null values. The null value substitutes are specified in the onedata.properties file. Terracotta uses these substitutes instead of the null values while indexing.
The properties in onedata.properties file and their default values are listed below.
Important:
The substitute values for null values are used only for indexing purpose and are not expected to be part of the data. If you expect the substitute value in your data, you can customize the value by editing the onedata.properties file located at < Software AG_directory
OneData Property
Specifies the substitute for a null value of data type...
Default Substitute Value
onedata.terracotta. numeric.nullvalue
NumericContiguous
SequenceDatabase
SequenceExternal
SequenceOptional Database
SequencePercentageBoolean
-2147483648
onedata.terracotta. string.nullvalue
CharVarcharFile Type
OD#NULL#OD
onedata.terracotta. date.nullvalue
DateTimestamp
1970-01-01 00:00:00
Note:
You must use the date format YYYY-MM-DDHH24:MM:SS