NEW4.01.01 · Released 24 June 2024

NEWfinPOWER Connect

Released in

4.01.01

24 June 2024

1. Opened19 Apr
2. Closed19 Apr
3. Released24 Jun

Article 21385 Job J033345

HTML Widgets; Parameters Host Control; "Standard Range" Range Parameters can now have the SQL Where updated by using the UpdateParameters function

Previously, the UpdateParameters(parameters, options) function on the Parameters Host control could only be used to update the SQL Query on a Parameter. This was only useful for Range Parameters which were configured as SQL Queries.

This function now supports updating the SQL Where for Range Parameters which are configured as Standard Ranges.

To support this, the following options can be specified to the function:

• rangeLookupSql (existing option, indicates if the function should update SQL Query type Parameters).
• rangeLookupSqlWhere (new option, indicates if the function should update the SQL Where for Standard Range type Parameters).
• all (new option, equivalent of both rangeLookupSql and rangeLookupSqlWhere being True).