Page Comparison

...

Create a form from the Database Connector schema (productDetails) to insert a record to into the products table in an external database named classicmodels. We have added a Trigger control to make testing the rules easier. The MySQL classicmodels database has a table named products. When we execute the rule in our frevvo form, we want to insert a record to into this database table.

Here is an image of the form:

This query is included in the configuration.xml.

...

A Doc URI - this is the simplest way but the Doc URI is only executed when a form is submitted or a flow has completed it’s final step. When the user submits the form, the URI will be executed with the POST method selected from the dropdown. The database connector will execute the Insert operation identified by the URI.
Code Block
http://localhost:8082/database/BIRT/productDetails

A business rule to pass the data to the database connector post using URL query parameters. Business rules execute in a form/flow when the specified condition is met. When the user clicks on the Trigger control, the database connector will execute the Insert operation identified by the URI in the productDetails query in the configuration.xml file..

Code Block

language	js

if (trigger.clicked) {
  var PostURL = 'http://localhost:8082/database/BIRT/productDetails?productCode=' + productCode.value + '&productName=' + productName.value + '&productLine=' + productLine.value + '&productScale=' + productScale.value + '&productVendor=' + productVendor.value + '&productDescription=' + productDescription.value + '&quantityInStock=' + quantityInStock.value + '&buyPrice=' + buyPrice.value + '&MSRP=' + MSRP.value;
  http.post(PostURL);
}

A business rule to create JSON to post/put in the http request. This method is preferred over method 2 because there is a limit to the length of the URL string which will limit the number of form fields you can pass to the Database Connector.

Code Block

language	js

/*member MSRP, buyPrice, productCode, productDescription, productLine, productName, productScale, productVendor, quantityInStock*/

if (trigger.clicked) {
  var jp = {
    productCode: productCode.value,
    productName: productName.value,
    productLine: productLine.value,
    productScale: productScale.value,
    productVendor: productVendor.value,
    productDescription: productDescription.value,
    quantityInStock: quantityInStock.value,
    buyPrice: buyPrice.value,
    MSRP: MSRP.value,
  };
  http.post('http://localhost:8082/database/BIRT/productDetails', jp);
}

Let’s analyze this rule:

The first line of the rule is the member directive required by the Live Forms rule validator
Conditional Line 2 is a conditional statement to specify that the rule runs when the Trigger control is clicked
var jp – defines the JSON payload variable
The next 9 lines define the JSON payload – specify the form field values that will be written to to the columns in the products table.
The last line specifies the http.post operation to the database connector using the JSON payload. When the user clicks on the Trigger control, the database connector will execute the Insert operation identified by the URI in the productDetails query in the configuration.xml file..

You can also use a combination of data passed by url parameters and JSON payload. Note that if a form field is specified both via a URL parameter and in the JSON payload, the URL parameter will take precedence. For example you can write a rule like this:

...

In this rule the value of “3” specified by the ?productCode=3 URL parameter will override overrides the value of the JSON object.

...

Versions Compared

Old Version 51

New Version 52

Key