...

Support for NULL or Blank Values

NULLs are supported in the DBConnector.

Let's say you have a database query to retrieve a row from a database table and a business rule to assign the retrieved values to fields in a form/flow. If the columns in the database table contain null or blank values, the rule fails with a “Cannot set ‘value’ as “undefined’ error because nothing is retrieved for these columns in the JSON results. As a work-around, a portion of the business rule was created to check if values are being returned from columns before assigning it to a form field. This had to be done for every column value in every query.By default, optional/empty form fields will send a null from the form field to the Db Connector and return an xml element or json property for an optional/empty form field when the database column contains a null. This is controlled by the emit null feature.

if you prefer optional/empty form fields to send/return an empty string, you can disable this behavior for the whole db connector or at the queryset/query level.

Disabling the emit null feature can

Stored Procedures

You can also execute stored procedures via the database connector. Here is an example of a mySql stored procedure.

...