Web Channel
- Fixed URL links that referenced filters that contained <in> or !<in> lists only passed the first value. Now passes the full list. Also, if the reference was the Super field this caused an Expression error as the value was not quoted.
Query Builder
- Fixed Query Builder Expression error when previewing data of a Drill Through
Scheduler
- Fixed Query Combinations Filter Parameters did not always work when setting both the from and to values if the target filter was blank or had a operator like <in> or <like>
- Added Writeback Mapping so that CSV, Excel or Query results can be mapped to the writeback table along with defined fixed width fields. Type of mapping include map by column index or name, convert values with a mapping list, constants and expressions.
- Added more file io functions to JavaScript to allow both read and write text file streaming
Datamodels
- New syntax tag to allow multiple SQL statements to be executed on the same connection just before executing the main SQL select statement. The tags /*MoveSQLBlockExecuteBegin*/ and /*MoveSQLBlockExecuteEnd*/ can enclose multiple SQL statements separated with the keyword GO. This was introduced as some database platforms cannot execute mixed SQL statements in one execution depending on what’s been done. One use case would be to set the connection user details context for row level security in Oracle. These tags can be pleased in the root SQL where clause property of the table or in the table name. They are removed from the main SQL statement and executed one by one based on the GO separated and then the main SQL statement is executed all using the same connection object.