Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
2 Replies

Avatar

Correct answer by
Community Advisor

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.