Sample xml scanexport
From Agility
<?xml version="1.0" encoding="utf-8"?>
<export>
<configuration>
<separator>;</separator>
<textquote>"</textquote>
<newline>\r\n</newline>
<encoding>UTF8</encoding>
<header>Content-Type: text/xml</header>
</configuration>
<contents>
<!-- Usefull for export string expression functions:
Separator() - Returns separator defined in configuration
TextQuote() - Returns text quote defined in configuration
NewLine() - Returns new line defined in configuration
CsvEncode(arg1, arg2, ...) - Encode passed arguments to valid csv structure
XmlEncode(arg) - Encode argument to valid xml text
HtmlEncode(arg) - Encode argument to valid html text
-->
<const>
<![CDATA[
"<?xml version='1.0' encoding='utf-8'?>
<JobList>
"
]]>
</const>
<foreach table="woJob" datacontext="externalselectedkeys" classname="DataBO.ProcessMngt.JobBO">
<dbfilter>order by woJob.JobCode</dbfilter>
<variable>
<name>JobID</name>
<value>woJob.JobID</value>
</variable>
<data>
<![CDATA[
"<woJob>
<Credentials>
<Login>" + XmlEncode(#RemoteConnection.Login) + "</Login>
<Url>" + XmlEncode(#RemoteConnection.Url) + "</Url>
</Credentials>
<JobCode>" + XmlEncode(JobCode) + "</JobCode>
<Description>" + XmlEncode(FullDescription) + "</Description>
<JobStatus>" + XmlEncode(syJobStatus.Description) + "</JobStatus>
<JobType>" + XmlEncode(syJobType.Description) + "</JobType>
<StartDate>" + XmlEncode(StartDate) + "</StartDate>
<DueDate>" + XmlEncode(DueDate) + "</DueDate>
"
]]>
</data>
<foreach table="woJobTask" datacontext="database" classname="DataBO.ProcessMngt.JobBO" >
<dbfilter>woJobTask.JobID = #JobID</dbfilter>
<filter>if(Code = 'Completed', false, true)</filter>
<data>
<![CDATA[
" <woJobTask>
<TaskCode>" + XmlEncode(Code) + "</TaskCode>
<Description>" + XmlEncode(Description) + "</Description>
<TaskType>" + XmlEncode(syTaskType.Code) + "</TaskType>
<TaskStatus>" + XmlEncode(syJobStatus.Description) + "</TaskStatus>
</woJobTask>
"
]]>
</data>
</foreach>
<data>
<![CDATA[
"</woJob>
"
]]>
</data>
</foreach>
<const>
<![CDATA[
"</JobList>
"
]]>
</const>
</contents>
</export>