Actually the AquaScript is generated, but if you execute the AquaScript no rows are getting exported.
See sample template:
// specify connection
var conn = aqua.project.getServerConnection('Demo');
conn.connect();
conn.changeDatabase('Demo2');
function createWriter()
{
var wr = aqua.io.newTextWriter();
wr.setCellDelimiter(',');
wr.setQuoteIdentifier('\"');
wr.setOpenDateQuoteIdentifier('[');
wr.setCloseDateQuoteIdentifier(']');
wr.setFirstLineContainsColumnNames(true);
wr.setLineDelimiter('\r\n');
wr.setDefaultDateTimeFormat('yyyy-MM-dd hh:mm:ss');
wr.setDefaultDateFormat('yyyy-MM-dd');
wr.setDefaultTimeFormat('hh:mm:ss a');
wr.setDecimalSymbol('.');
return wr;
}
function exportTable(name, dest, query)
{
aqua.console.println('Exporting: ' + name + ' ...');
var rs = conn.executeQuery(query);
var wr = createWriter();
wr.setFile(dest);
wr.write(rs);
wr.close();
aqua.console.println('Export completed.');
}
function exportView(name, dest, query)
{
}
// exporting data
exportTable('OlympicAthletes', '/Users/tariq/Desktop/mdfu.xls', 'SELECT * FROM [OlympicAthletes_0].[OlympicAthletes]');
Actually the AquaScript is generated, but if you execute the AquaScript no rows are getting exported.
See sample template: