2021.2

Table Of Contents
OLConnect 2021.2 DataMapper Improvements
Improved custom SQL dialog
The interface for configure SQL queries has been improved for longer SQLqueries. The
interface now adapts based upon the display size and the length of the SQL query. (SHARED-
74633)
Simplified Boolean Conditional tests
A new "Is True" operator has been added to for Condition steps. This allows a condition to
check a boolean value directly without having to first supply a second operand. (SHARED-79342)
Determine the number of lines in the current record
Anew steps.lines property has been added. This property contains the number of lines in
each record for Text-mode data mapping configurations, which allows for much easier looping
through all the lines in a record. (SHARED-78996)
Improved Timestamp processing
A number of improvements in the DataMapper management of Date/Time fields have been
implemented. These allow for improved handling of time zones and of time stamps without time
zone information. (SHARED-77648)
Extract CSV data by column index value
Introduced a new java script function data.fieldExistsByIndex() to facilitate extraction based
on index. This allows the DataMapper to extract CSV fields by column index instead of column
names. This can be particularly useful for translated CSVs whose column headers change with
each language. (SHARED-80020)
General DataMapper Improvements
l Improved translations. (SHARED-81664)
Page 1524