- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
This is possible, by reading the temporary table created to hold the query data. (https://db.tt/aiCRLu3a66 )
- Add a Query and target recipient table
- Add complementary data (this is what you can use to query in the js activity and do stuff with it) https://db.tt/Ps2IRqkyil
- Add Js Activity with the following code and execute the workflow.
var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":") + 1);
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@email"/>
</select>
</queryDef>
);
result = query.ExecuteQuery();
for each (var e in result) {
logInfo(e.@email);
}