I have a query activity that feeds into a javascript code activity. One of the columns of data that I am feeding from the query uses an aggregate function: count(products_purchased). I am using xtk.queryDef api to write pull the results from the query and need to figure out how to pull this column in the following javascript code:
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select"
<select>
<node expr={count(products_purchased)} />
</select>
</queryDef>
).ExecuteQuery();
for each( var row in query)
logInfo("Total products purchased: " + row.count(products_purchased));