Article Details
Id:17049
Product:finPOWER Connect
Type:FIX
Version:3.03.02
Opened:29/05/2020
Closed:08/06/2020
Released:02/07/2020
Job: J024326
High Importance

HTML Widgets; Updated to cater for complex SQL WHERE in standard ranges

A recent security update means that standard ranges, e.g., Dropdown Lists refreshed to show something like Branches must use only 'simple' SQL WHERE clauses.

The following HTML Widgets have been updated to cater for this.

  • HtmlWidget_AccountAccountingLedger
    • Version: 1.05 (29/05/2020)
    • BranchFilter now encrypted since it could contain User-defined filters that would not pass 'simple' validation
    • Also updated so 'Advanced' button only appears on the first page of the wizard

NOTE: All changes involve encrypting any SQL WHERE clause that is passed from the Script Code to be used in the Template Text.