Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

xtk session write temp table

srikanthr646926
Level 2
Level 2

Update not working when adding data to temp table and Js is not throwing any error but it is updating any tow. Any suggestions

var schemaName = vars.targetSchema.substring(vars.targetSchema.indexOf(":") + 1);

logInfo("Schem name = " +schemaName);

var formatString = function(str) {
   
       blah blah blah..........................
   

    return str;
}

var query = xtk.queryDef.create(
         <queryDef schema={vars.targetSchema} operation="select">
          <select>
            <node expr="@Label"/>
            <node expr="@FullName"/>
            <node expr="@lineNum"/>
          </select>
         </queryDef>);
  
var resultSet = query.ExecuteQuery();
for each (var row in resultSet.enrich5)
{
//instance.vars.Label=formatString(row.@Label);
//logInfo(formatString(resultSet.enrich5.@Label));
xtk.session.Write(<query _operation="update" _key="@lineNum" Label= {formatString(row.@Label)}  xtkschema="temp:enrich5"/>);

}

5 Replies
daniell35335226
Level 2
Level 2

Hi

Here is working code that I have; maybe this will help:

     xtk.session.Write(&lt;query xtkschema="temp:query" _key="@id" id={id} email={email} status={status} status_description={status_description} date={date} /&gt;)

Let me know if that works.

Dan

srikanthr646926
Level 2
Level 2

It's not working. Can you please let me why there is no reference of querydef variable or operation=update in the above code.

kapilsharma0101
Level 4
Level 4

Hi Srikanth,

Instead of using the xtk.Session.Write, you can use the below statement to update the TempSchema :

sqlExec("update "+vars.tableName +" set abc='0' where bcd="+123);

Let me know if this works.

Regards,

Kapil