Solved
What is the key field for records in a temporary schema? How to update records in the temp schema using JavaScript
I have created a field in a workflow temporary schema (for the sake of this example, called fieldToUpdate).
I have a JavaScript activity and I want this to update the content of the field 'fieldToUpdate' to "Y" for record flowing through the activity as follows:
var myXML =
<queryDef schema="temp:query3" operation="select">
<select>
<node expr="fieldToUpdate"/>
</select>
</queryDef>
var query = xtk.queryDef.create(myXML)
var res = query.ExecuteQuery()
for each (var rcp in res.query3){
var myXMLwrite = <query3 xtkschema="temp:query3" fieldToUpdate="Y" operation="insertOrUpdate" _key="???"/>;
xtk.session.Write(myXMLwrite)
}
I am able to update persistent schemas without difficulty, but my inability to identify the key value for rows in a temporary schema is blocking my progress here.
