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.