Writing work table data in a Temp Table | Community
Skip to main content
varshtus
varshtus
Level 2
September 16, 2020
Solved

Writing work table data in a Temp Table

  • September 16, 2020
  • 3 replies
  • 5267 views

Hi -

 

I have created a Temp table via JS in my workflow and want to insert data from the working table in that temp table, is it possible?

 

If yes can you help me with JS for it?

 

Regards,

Tushar Varshney 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidKangni

Hi,

 

You may fetch temp schema like this:

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

logInfo(schemaName);

var query = xtk.queryDef.create(

<queryDef schema = {vars.targetSchema} operation = "select">

<select>

<node expr = "@firstName"/>

<node expr = "@lastName"/>

<node expr = "@email"/>

<node expr = "@id"/>

</select>

</queryDef>);

If you are sure in this above, you may try this for writing:

var some_variable = <vars.targetSchema.split(':')[1]

xtkschema = vars.targetSchema

_key="@id"

_operation="Update"

lastName = {record.lastName }

firstName={record.firstName}

email = {record.email }

/>;

xtk.session.Write(some_variable);

Thanks,

David

3 replies

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
September 17, 2020

Hi,

 

You may fetch temp schema like this:

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

logInfo(schemaName);

var query = xtk.queryDef.create(

<queryDef schema = {vars.targetSchema} operation = "select">

<select>

<node expr = "@firstName"/>

<node expr = "@lastName"/>

<node expr = "@email"/>

<node expr = "@id"/>

</select>

</queryDef>);

If you are sure in this above, you may try this for writing:

var some_variable = <vars.targetSchema.split(':')[1]

xtkschema = vars.targetSchema

_key="@id"

_operation="Update"

lastName = {record.lastName }

firstName={record.firstName}

email = {record.email }

/>;

xtk.session.Write(some_variable);

Thanks,

David

David Kangni
    Manoj_Kumar
    Community Advisor
    Manoj_KumarCommunity Advisor
    Community Advisor
    September 21, 2020

    Hello @varshtus ,

     

    I am assuming you have created a temp table with the JS and it is not created by any activity.

     

    To read the data from the previous activity and store it in the temp table you can use this javascript code.

    //reading the data rom the previous activity var query = xtk.queryDef.create(<queryDef schema={vars.targetSchema} operation="select"><select><node expr="@id"/><node expr="@COLUMN1"/></select></queryDef>); var resultSet = query.ExecuteQuery(); // Writing the data into the temp table for each (var row in resultSet) { var COLUMN1= row.@COLUMN1; var pId= row.@id; sqlExec("INSERTO INTO TEMP_TABLE_NAME values("+COLUMN1+","+pID+")); }

     

    Let me know if that works.

     

    Thanks

     

     

     

    Manoj     Find me on LinkedIn
      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      October 1, 2020

      Hi @varshtus,

      Were you able to resolve this query with any of the given solutions? Do let us know.

      Thanks!

      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...