Example: Marshal with Combine Project

The Allora project in the screenshot below demonstrates how to use the settings on the XML Structure tab to control the appearance of XML output when marshalling data from a database to XML. The XML output from the project shows a very limited data set (created using a predicate to retrieve only records where ORDERID = 1) so that the structure of the output is easy to follow.

The examples below show how the XML output changes depending on settings in the XML Structure tab:

 

1.

Marshal Without Combine

No settings have been made in the XML Structure tab

2.

Marshal with Combine

XML output combines all PurchaseOrder nodes that have a matching value for the OrderID node.

3.

Marshal with Combine and Group

 XML output groups  all matching elements (LineItem) together

4.

 

Marshal with Combine and Order By

XML output contains records retrieved from the database using an ORDER BY clause

5.

Marshal with Optimized Combine

XML output generated using the Optimized Combine feature in the XML Structure tab.

 

See Also

XML Structure Tab
Introduction to Combining Nodes in XML Output when Marshalling
Combining Duplicate Elements in XML Output
Customizing Combine Settings for XML Output