...
Code Block | ||
---|---|---|
| ||
// Export corporations with the subcorporations Database.ExportToXml({ Parameters : { TargetSchema : 'Evrak', TargetTable : 'Kurum' }, XPath : 'Corporations/Corporation', SubQueries : [ {Name : 'SubCorporations'} ] }); |
Info |
---|
Assume you have two SQL tables Corporations and SubCorporations and a One-To-Many relation from Corporations table to SubCorporations table which is also named SubCorporations. Also don't forget to set this relation's update rule to "Cascade". Having defined the table columns with identical names to the XML fields, this code lets you export each corporation from SQL table into XML fields, exporting also its related SubCorporations into the SubCorporations XML nodes and resulting in the following XML data. |
Example
Exported XML Data
Code Block | ||
---|---|---|
| ||
<GeneralDefinitions> <Corporations> <Corporation> <Id>9b7383a3-67ae-4fed-a135-1f981b165c43</Id> <Name>Corporation A</Name> <ShortName>CorpA</ShortName> <SubCorporations> <SubCorporation> <Id>309069b4-4274-4063-b7ad-75c5657d7474</Id> <Name>SubCorporation A 1</Name> <ShortName>SubCorpA1</ShortName> </SubCorporation> <SubCorporation> <Id>6ba3cc79-9ff7-4232-8f61-9245a38fd2bb</Id> <Name>SubCorporation A 2</Name> <ShortName>SubCorpA2</ShortName> </SubCorporation> </SubCorporations> </Corporation> <Corporation> <Id>5a900112-a869-41cf-931c-7379c1df518e</Id> <Name>Corporation B</Name> <ShortName>CorpB</ShortName> <SubCorporations> <SubCorporation> <Id>8e7ca6d2-5629-4f87-82ed-73c72cfb171e</Id> <Name>SubCorporation B 1</Name> <ShortName>SubCorpB1</ShortName> </SubCorporation> <SubCorporation> <Id>7c5f330e-68d8-45f0-800e-04e2f7e035e0</Id> <Name>SubCorporation B 2</Name> <ShortName>SubCorpB2</ShortName> </SubCorporation> </SubCorporations> </Corporation> </Corporations> </GeneralDefinitions> |
...