 |
|
|
 | Selecting Records for Output to XML Using Variables |  | XML Support | Create Database Tables and Transfers Based on an XML Schema |  |
Depending on the data, a certain degree of variability to the XML output may be acquired. Certain elements or attributes can appear in XML, only if certain conditions are fulfilled in the data. If the condition for element output is not fulfilled, nothing inside this element will be in the output.
The condition that specifies whether an element should be in XML can be specified in the element description in the Element output condition field. The condition that specifies whether an attribute should be in XML can be specified in the attribute description in the Output condition field.
The condition in an analytic DAD is a predicate in the SQL language. You may use any expression that will result in a boolean value.
If you use the DAD containing conditions for transferring data from XML to a database, these conditions will be ignored.
You can only use the column name from the query as a condition in a synthetic DAD. This column must be a boolean type.
If the condition is expressed with a expression, you must add this expression to the SELECT section in the query and mark it with an identifier using the AS clause. Specify the identifier in the field for the condition in the description of the appropriate element or attribute.
| Selecting Records for Output to XML Using Variables | | XML Support | Create Database Tables and Transfers Based on an XML Schema | |