JS to return schema?
Hi guys,
Is it possible to Query a schema, send it to a Javascript to apply a <where> condition and then return the schema result, therefore send it to another flow activity? I have tried it without result.
Here's my js
query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select" distinct="true" noLineCount="1">
<select>
<node expr="@field1" alias="field1"/>
</select>
<where>
<condition expr={"@field1='" + localVar + "'"}/>
</where>
</queryDef>);
resultSet = query.ExecuteQuery();
return resultSet;