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

SOLVED

Writing work table data in a Temp Table

varshtus
Level 2
Level 2

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 

1 Accepted Solution
DavidKangni
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

0 Replies
DavidKangni
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

Manoj_Kumar_
Community Advisor
Community Advisor

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

 

 

 

Sukrity_Wadhwa
Employee
Employee

Hi @varshtus,

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

Thanks!