Sample csv
From Agility
<?xml version="1.0" encoding="utf-8"?>
<export>
<configuration>
<separator>;</separator>
<textquote>"</textquote>
<newline>\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>
"JobCode" + Separator() + "Desc" + Separator() + "StartDate"+ Separator() + "Due" + NewLine()
</const>
<!-- datacontext = dataset | database | query [default: dataset] -->
<foreach table="woJob" datacontext="database" classname="DataBO.ProcessMngt.JobBO">
<!-- DBFilter is optional and valid for database-related export table only-->
<dbfilter>woJob.StartDate >= DATEADD(NOW(), 'MONTH', -6) order by woJob.StartDate</dbfilter>
<data>
CsvEncode( JobCode, FullDescription, StartDate, DueDate ) + NewLine()
</data>
</foreach>
</contents>
</export>