What is the key field for records in a temporary schema? How to update records in the temp schema using JavaScript

[Dandrews2]

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.

[Pradeep_Kumar_Srivastav · Accepted solution]

Hi @Dandrews2 , See if this helps https://technowide.net/2017/05/19/iterating-custom-functions-record/

[Dandrews2]

Thanks for sharing Pradeep

In the end I used a different method to solve my issue, but the above should prove a useful resource anyway.