Sample xml dataset mode
From Agility
<?xml version="1.0" encoding="utf-8"?>
<export>
<configuration>
<separator>;</separator>
<textquote>"</textquote>
<newline>\r\n</newline>
<encoding>UTF8</encoding>
</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="dataset" classname="DataBO.ProcessMngt.JobBO">
<dbfilter>woJob.StartDate >= DATEADD(NOW(), 'MONTH', -6) order by woJob.StartDate MAXRESULTS 5</dbfilter>
<data>
<![CDATA[
"<woJob>
<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">
<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>