...
Query of data to export.
When IncludeAllColumns parameter is not specified, default behavior is query returns only explicitly specified columns. If not any column specified query returns the all defined columns on table.
The design of your XML data model and SQL table columns are the key point for the ease of use. When XML node and table column names identical, this method maps them automatically.
...
| Code Block |
|---|
|
$Database.ExportToXml({
TargetSchema : 'MySchema',
TargetTable : 'Accounts',
XPath : 'Accounts/Account',
Map : function (accountXml) {
this.Password = 'Enc:' + this.Password; // mark as encrypted
this.AccountType = accountXml.Evaluate('Type/Code'); // map values whose names are not identical to SQL column names
}
}); |
Example
Exporting database content into XML
| Code Block |
|---|
|
// For following xml structure
// <Root>
// <Groups></Groups>
// </Root>
$Database.ExportToXml({
Parameters : {
TargetSchema : 'HR',
TargetTable : 'Groups'
},
XPath : 'Groups/Group',
Order : [
{Name : 'Name', Type : 'Ascending'}
]
});
// Xml updated as;
// <Root>
// <Groups>
// <Group>
// <Name>Developers (Junior)</Name>
// </Group>
// <Group>
// <Name>Testers</Name>
// </Group>
// </Groups>
// </Root> |
Example
Exporting with sub queries
| Code Block |
|---|
|
// Export corporations with the subcorporations
Database.ExportToXml({
Parameters : {
TargetSchema : 'Evrak',
TargetTable : 'Kurum'
},
XPath : 'Corporations/Corporation',
SubQueries : [
{Name : 'SubCorporations'}
]
}); |
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> |
Example
Exporting with nested sub queries
| Code Block |
|---|
|
$Database.ExportToXml({
Parameters : {
TargetSchema : 'Contract',
TargetTable : 'Events'
},
Where : {
Criteria : [
{Name : 'ReminderDate', Value : $Calendar.Today, Comparison : 'LessThan'},
{Name : 'Durum', Value : 'IPT', Comparison : 'Different'},
{Name : 'Type', Value : 'R'},
{Name : 'Status', Value : 'W'}
]
},
SubQueries : [
{
Name : 'Contract',
Parameters : {
IncludeAllColumns : 'True'
},
SubQueries : [
{
Name : 'Party'
},
{
Name : 'Versions'
},
{
Name : 'Events'
}
]
}
],
XPath : 'ContractEvent',
Order : [
{Name : 'ReminderDate', Type : 'Descending'}
]
}); |
Example
Exporting with XML mappings
| Code Block |
|---|
|
$Database.ExportToXml({
Parameters : {
TargetSchema : 'HR',
TargetTable : 'OrganizationUnitPositionMembers',
IncludeAllColumns : 'True'
},
Columns : [
{
Name : 'Employee',
Properties : {
XPath : 'Id'
}
},
{
Name : 'Employee.Person.DisplayName',
Properties : {
XPath : 'Name'
}
},
{
Name : 'OrganizationUnitPosition.Organization',
Properties : {
XPath : 'Department'
}
},
{
Name : 'OrganizationUnitPosition.Organization.Name',
Properties : {
XPath : 'Department/@Name'
}
}
],
Where : {
Criteria : [
{
Name : 'OrganizationUnitPosition.Manager',
Value : 'D7B70176-C44D-44BB-A8C0-7900BC5DAF2A',
Condition : 'And'
},
{Name : 'Employee.User.Disabled', Value : true, Comparison : 'Different', Condition : 'And'}
]
},
XPath : 'EmployeeList/Employee'
}); |
...