...
- 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. Click the Next button.
- You should see the Document name change to 'orderDetailsByOrder', which is the data source we are interested in.
- Set the URL to: http://localhost:8082/database/BIRT/orderDetailsByOrder?onum={so}.
- Set the Read method to GET.
- Click the Finish button.
]
This step indicates to that the 'orderDetailsByOrder' document is linked to the above URL via the READ method GET. 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.
...
- 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. Click the Next button.
- You should see the Document name change to 'createOrder', which is the data source we are interested in.
- Set the URL to: http://localhost:8082/database/BIRT/createOrder.
- Leave the Read method empty.
- Set the Write method to POST.
- Click the Finish button.
This step indicates to that the 'createOrder' document is linked to the above URL via the WRITE method POST. When the form is submitted, will issue an HTTP POST request to the above URL sending the createOrder XML document in the payload. The database connector will map this to the <create> operation of the createOrder query that we defined above, will use the data in the XML document to resolve the query (replace {cnum} and {onum} with values from the XML) and perform the INSERT.
...
- 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.
...