FIX4.00.01 · Released 20 March 2023
FIXfinPOWER Connect
Released in
4.00.01
20 March 2023
  1. Opened1 Dec 2022
  2. Closed1 Dec 2022
  3. Released20 Mar
Article 19777 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.