Therefore Programming Interface 3.0

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Printable Version
Save Permalink URL

What's new in Therefore™ 2018

New feature: Culture sensitive query conditions

Additional to the language sensitive query conditions introduced in Therefore™ 2017, additional options are available in Therefore™ 2018. The new class TheCultureInfo provides the possibility to specify an LCID for language, an extra LCID for formats for Date, DateTime and Decimal field condition values and a custom time zone to enable the possibility to use local date and time values from a different client that may use a different time zone, language and format.

Modified feature: Money Fields become Decimal Fields

The field type Money has been transformed to the field type Decimal. Decimal fields will now return a value of type decimal instead of double. Decimal values can be converted to double and vice versa.

Setting a double or float value on a TheIndexData object is still supported.

For compatibility reasons fields that are specified with length 15 and scale 2 (all previous Money fields will have this configuration) will still be returned as double value.

Decimal fields are more precise and support a configurable number of decimal digits that can be different for each decimal field.

If there are too many decimal digits in a value, the value will be rounded to the next even number.

Double values are not precise. At a certain number of digits the value can contain errors. Make sure to consider this when working with Decimal fields and using more than 15 digits in total.

For Decimal fields TheCategoryField.Length specifies the total number of digits for the number, including the decimal digits.

TheCategoryField.Scale specifies the number of decimal digits.

New feature: DateTime Fields

The new field type TheCategoryFieldType.DateTimeField holds a date and a time value. Therefore™ stores these values in UTC, expects the values to be set in UTC and returns them in UTC. The bIsUTC parameter in TheConditionList.Add and the property TheCondition.IsUTC can be used with DateTime fields to enable the possibility of setting query conditions in the local time zone without worrying about the time zone conversion.

In addition to this the new class TheCultureInfo provides the possibility to set a different time zone that is used for converting query conditions correctly if necessary as well as the string format for Date, DateTime and Decimal fields.

New feature: Multi Language Keyword Dictionaries and Workflow Processes

With Therefore™ 2017 it is possible to configure the visible text in categories and case definitions including fields and tabs in different languages. Now this feature can also be used with following classes:

The concept is the same as with categories and case definitions, as are newly added methods and their names. For reference see What's New in Therefore 2017.