...
- Click on the Doc Action button in the toolbar at the top of the form.
- In the dialog box that appears click on 'Manually set document URIs'.
- A new dialog box will appear. Navigate to the desired document (createOrderDetail) by clicking the Next button twice.
- Set the URL to: http://localhost:8082/database/BIRT/createOrderDetail.
- Leave the Read method empty.
- Set the Write method to POST.
- Click the Finish button.
When the form is submitted, will issue an HTTP POST request to the above URL sending the createOrderDetail XML document in the payload. The database connector will map this to the <create> operation of the createOrderDetail query that we defined above, will use the data in the XML document to resolve the query. Since there are multiple line items, the query will be executed once for each Order line item thereby inserting the multiple line items for an Order.
...
- Click on the Doc Action button in the toolbar at the top of the form.
- In the dialog box that appears click on 'Manually set document URIs'.
- A new dialog box will appear. Navigate to the desired document (customerCreditLimit) by clicking the Next button.
- Set the URL to: http://localhost:8082/database/BIRT/customerCreditLimit?cnum={sc}.
- Set the Read method to GET.
- Set the Write method to PUT.
- Click the Finish button.
]]
This step indicates to that the 'customerCreditLimit' document is linked to the above URL via the READ method GET and the WRITE METHOD PUT. will issue an HTTP GET request to the above URL and if an XML document conforming to the schema above is returned, will automatically initialize controls in the form using that document. The URL itself is a dynamic URL and has a parameter indicated by {sc}. When the value of the control named 'sc' changes (which will happen when the user selects a customer), will automatically issue an HTTP GET to the above URL using the new customer number and will dynamically update the values of the credit Limit and cnum controls without refreshing the form.
...