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)