xtk session write temp table
Update not working when adding data to temp table and Js is not throwing any error but it is updating any tow. Any suggestions
var schemaName = vars.targetSchema.substring(vars.targetSchema.indexOf(":") + 1);
logInfo("Schem name = " +schemaName);
var formatString = function(str) {
blah blah blah..........................
return str;
}
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@Label"/>
<node expr="@FullName"/>
<node expr="@lineNum"/>
</select>
</queryDef>);
var resultSet = query.ExecuteQuery();
for each (var row in resultSet.enrich5)
{
//instance.vars.Label=formatString(row.@Label);
//logInfo(formatString(resultSet.enrich5.@Label));
xtk.session.Write(<query _operation="update" _key="@lineNum" Label= {formatString(row.@Label)} xtkschema="temp:enrich5"/>);
}