Expand my Community achievements bar.

xtk session write temp table

Avatar

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

Avatar

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

Avatar

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.

Avatar

Employee Advisor

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