Article Details
Id: | 19777 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 4.00.01 |
Opened: | 01/12/2022 |
Closed: | 01/12/2022 |
Released: | 20/03/2023 |
Job: | J030117 |
HTML Widgets; widget.UI.Forms.ShowRangeLookupFromStandardRange Function now supports Encrypted SQL for option "sqlWhere" when run in finPOWER Connect Desktop
The widget.UI.Forms.ShowRangeLookupFromStandardRange accepts a "sqlWhere" option. Previously, this did not work if the SQL had been passed through the finBL.HtmlWidgetUtilities.EncryptSql Function and the HTML Widget was being run in finPOWER Connect Desktop (it worked fine if running from Web Services).
This has been updated, and now Encrypted SQL will be correctly recognised in the context of finPOWER Connect Desktop.
Note: It is advisable to encrypt all SQL being passed client-side in HTML Widgets.