Obsolete SQL functions replaced with secure methods

As of versions 2.2.0.388 and 2.2.1.145, new rules related to the use of deprecated formulas in the system have been made available.

Since December 31, 2024, workflows cannot be started if deprecated formulas are detected in forms or process activities. However, instances that were already under execution can keep using the formulas without interruption.

The EXECUTESQL, OPENSQLZOOM, and UPDATEGRIDZOOMSQL functions were deprecated in version 2.1.3 and, as of June 30, 2025, they will cease to be executed by the system. 

These calls must necessarily be replaced with the new QUERYEXECUTE, QUERYZOOM, and QUERYZOOMTOGRID functions, respectively. 

This change significantly strengthens security, as it prevents SQL commands from being added directly to formulas. 

The new functions require that an SQL command be added beforehand (directly to the form or through a shortcut on the task bar), ensuring greater control and protection for the data.

EXECUTESQL function replaced

The EXECUTESQL function used to execute an SQL command and assign the result to form fields. 

For example, in order to fetch the leader of a user inserted in the ID # field and record this value in the Leader field, we would use:

To adopt the new approach, follow the steps below:

1. Create the SQL query in the Queries section. In Queries, set the command that fetches leaders from user IDs.

2. Replace the obsolete EXECUTESQL formula with the new QUERYEXECUTE function. Use the ID # of the added query and specify the fields that will receive the query return.

For example:

This way, the whole SQL remains recorded in the Queries section, and only the ID # is referenced in the form formula.

OPENSQLZOOM function replaced

The OPENSQLZOOM function used to display the records resulting from an SQL query and assign selected records to specific form fields. 

Suppose it would be used to list departments and assign the chosen one to the Department field:

In order to migrate to the new standard, follow the steps below:

1. Create the SQL query in the Queries section. Create a query that returns the departments, with columns, such as name.

2. Replace OPENSQLZOOM with QUERYZOOM: 

• Use the query ID #.
• Specify the fields that will receive the values of the selected record.
• Choose which columns will be displayed in the zoom.

For example:

Thus, the presentation logic of the records and their assignment to the form are centralized in the configuration of the Queries section, ensuring greater clarity and security.

UPDATEGRIDZOOMSQL function replaced

The UPDATEGRIDZOOMSQL function used to display records returned by an SQL query and assign the selected items to a form table (grid). For example, to list products and add them to the table.

To adopt the secure method, follow the steps below:

1. Create the SQL query in the Queries section. Create a query that fetches the products, including columns such as name and price.

2. Replace UPDATEGRIDZOOMSQL with QUERYZOOMTOGRID: 

• Use the query ID #.
• Enter the table relationship ID #.
• Specify the fields that will receive the values.
• Indicate whether the table must be cleared before the update (TRUE/FALSE) and specify the columns that will be shown to the user. 

For example:

This way, the display and insertion of records in the table are totally linked to the previously defined queries, which increases the consistency and security of the form.

Form records with obsolete formulas updated

Form records use the current revision from when they were created. Even if new revisions are generated, these records remain linked to that version. 

To apply the new rules and, consequently, the new functions to existing records, the revision must be updated manually. To do so, follow the steps below:

1. Access the Management > Revision (FO017) menu.

2. Search for the name of the form whose revision will be updated and select it.

3. Click on More and select the Replace obsolete revision option.

4. Select the revision that contains the deprecated formulas and confirm the change.

After this action, all the records linked to the former revision will be migrated automatically to the current one and will start to use the new query functions.

With these changes, the use of the new QUERYEXECUTE, QUERYZOOM, and QUERYZOOMTOGRID functions must ensure greater security and organization for the development of formulas in forms, as the whole SQL will be centralized in the Queries section, no longer being embedded directly in the formulas.