Article Details
| Id: | 17014 |
| Product: | finPOWER Connect |
| Type: | FIX |
| Version: | 3.03.02 |
| Opened: | 29/05/2020 |
| Closed: | 17/06/2020 |
| Released: | 02/07/2020 |
| Job: | J024325 |
 High Importance |
|
HTML Widgets; New Account wizard; Maturity Account dropdown is read-only
Due to recent changes to secure SQL WHERE clauses specified in standard ranges such as a dropdown of Accounts, the Maturity Account in the New Account wizard failed to display a list of Accounts and instead, stayed read-only.
Sub-queries are no longer allowed in client-side (Template Text) filters. To remedy this, the SQL WHERE must be encrypted in the Script code using finBL.HtmlWidgetUtilities.EncryptSql, e.g.:
.MaturityAccountFilter = finBL.HtmlWidgetUtilities.EncryptSql(swb.SqlWhere)
The following HTML Widgets have been updated:
- HtmlWidget_AccountNew
- Version: 1.09 (17/06/2020)