...
{ // Comparison operator. Default value is Equals. Comparison : ( "Equals" | "Different" | "LessThan" | "GreaterThan" | "LessThanOrEqualTo" | "GreaterThanOrEqualTo" | "Like" ) // Condition with next criteria. If not specified And value is used. Condition : ( "And" | "Or" ) // Criteria expression. Expression : string // Array of ignored values. IgnoredValues : any // Value or Expression to compare Value : any // Type of value. If not specified Direct value is used. ValueType : ( "Direct" | "Expression" ) }
Examples
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
}
}); |
...
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> |
...
Code Block |
---|
|
// Export corporations with the subcorporations
Database.ExportToXml({
Parameters : {
TargetSchema : 'Evrak',
TargetTable : 'Kurum'
},
XPath : 'Corporations/Corporation',
SubQueries : [
{Name : 'SubCorporations'}
]
}); |
...
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> |
...
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'}
]
}); |
...
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'
}); |