DB to XML
With the DB to XML block, you can define the data structure for transferring data from the database to XML variables.
In practice, this means that you can use the selected data from the database in your workflow.
The block can be accessed from the menu Settings | Documentation | Workflow Design by clicking the panel Design | Input/Output.
Double-clicking the DB to XML block opens the DB to XML window, which is divided into two parts:
1. Input field
Enter SQL queries to retrieve data from the database.
2. List of SQL field names with workflow variables
The bottom part of the form shows the following elements:
|
 (Run SQL)
|
Runs the above SQL query and the list below is populated with SQL field names.
|
|
 (Fill variables)
|
Writes the value from the SQL query field to the workflow variable.
|
|
SQL field name
|
This field is populated with SQL field names.
|
|
WF variable
|
Enter workflow variables to be linked with SQL query fields.
|
 |
WARNING
Only one record can be read.
|
 |
HINT
For more information on how to use the DB to XML block, see the User manual for eWorkflows.
|