IWS Release Notes - Version 1.0.1.293

Owned by Former user (Deleted)
Last updated: Sept 04, 2024 by Kinga Huszno
2 min read

Initially released to IWS Test on 20141001

Enhancements

Enhanced Custom SQL Requests By Adding New XSLT SQL DB Lookup
The ability to run a custom SQL request in the XSLT worksheet has been enhanced. As of this release, there is a new XSLT SQL DB Lookup object. You can set custom SQL requests and insert to them variables (including, from source table). The result of the lookup can be linked to the destination table or other input objects. 

In an earlier IWS release (v.1.0.1.283), the ability to add custom SQL requests was initially announced. However, this initial release proved to be limited and difficult to use. Therefore, the code was revisited and enhanced. As a result of this refactoring, the new XSLT SQL DB Lookup object was introduced.

This issue was tracked as Item #123352.


XSLT Edit Check Added To ForEach Subworksheets
XSLT Edit Check has been added to ForEach subworksheets. If the expression in the Edit Check condition is evaluated to true, then following nodes will be added into result XML for each ForEach iteration:

<reason> <reasonTypeEnum>[severity_type]</reasonTypeEnum> <reasonCode reasonCodeScheme="http://www.eagleinvsys.com/coding-scheme/reason-code">[code_value]</reasonCode> <description>[description_value]</description> <reasonTag>[reason_tag_value]</reasonTag> </reason>

This issue was tracked as Item #123354.


Enhancements to XSLT ForEach Subworksheet
The XSLT ForEach Subworksheet was enhanced. The Destination grid has been added inside the XSLT ForEach subworksheet. In addition, the source and destination grids inside the XSLT ForEach subworksheet will be filled based on nodes, which is linked to the parent ForEach element in the root worksheet. This means if you create a ForEach element and link it with children nodes in root XSLT worksheet, only the content of these children nodes will be displayed inside ForEach subworksheet. Another enhancement is that you can now change the mapping inside the ForEach subworksheet. The mapping on the root worksheet will be synchronized automatically. As a design note, if a ForEach object contains any elements in its subworksheet then a blue circling arrow image will be displayed in the ForEach in the right top corner.
This issue was tracked as Item #123356.

Software Fixes

Incorrect Syntax Helper for XSLT
The wrong syntax helper was associated with XSLT DB Lookup and XSLT ForEach subworksheets. The code was updated to resolve this issue.
This issue was tracked as Item #123353.


Scrollbar Issue
There was an issue with the scrollbar for battingOrder and assetResolutionOption nodes. The code was updated to resolve this issue.
This issue was tracked as Item #123357.


Incorrect Edit Border Indicator After Scrolling
The position of "red border" indicator displayed around editing a cell in the source or destination grids was incorrect after you scrolled in these grids. The code was updated to resolve this issue.
This issue was tracked as Item #123358.