Can we store instance variable into an array?
Using queryDef am fetching a no sql field (an XML say 'ctx') field. Is there is any way to store the results in the array and then use the enrichment so that I can add these variables to the final data?
Using queryDef am fetching a no sql field (an XML say 'ctx') field. Is there is any way to store the results in the array and then use the enrichment so that I can add these variables to the final data?
Hi saishag86196293 ,saishag86196293
You can store the query results in an array using for each loop in the query result and store it in vars to use it further in upcoming activities.

Below is the code text:
var query = xtk.queryDef.create(
<queryDef schema="xyz:transient" operation="select">
<select>
<node expr="@id"/>
<node expr="@campId"/>
<node expr="@recCount"/>
</select>
</queryDef>)
var res = query.ExecuteQuery()
//Creating array to store all Id's
id = []
for each (var t in res.transient){
id.push(t.@id)
}
logInfo('id array' + id);
//Store id array in vars to use it in next activities
vars.idArray = id;
logInfo('vars.idArray ' + vars.idArray);
Thanks,
Nainy Jain
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.