How to update data in tables Using Java Script? | Community
Skip to main content
R
ramprakasht3196
Level 3
August 21, 2019
Solved

How to update data in tables Using Java Script?

  • August 21, 2019
  • 1 reply
  • 4402 views

I have to update the data which is already available in custom schema using API. For that I am using Below java script snippet.

Workflow is Running without any error. But The data is not updated in tables. Please help me to solve this.

var query = xtk.queryDef.create(

     <queryDef schema= "temp:fileImport" operation="select"> 

     <select>   

     <node expr="firstName"/>

     <node expr="lastName"/>

     <node expr="email"/>

     <node expr="city"/>

     </select>  

  </queryDef>)

var results = query.ExecuteQuery();

for each ( var record in results.fileImport) {

                 logInfo("record --"+record.firstName);

                  xtk.session.Write(<query xtkschema="ram:customer" _operation="update" _key="@firstName" city = {record.city} firstName={record.firstName} />);

 

}

Regards,

Ramprakash.

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 Milan_Vucetic

Hi Ramprakash,

It can be that your query doesn't return anything so there is no update.

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="city"/>

     </select> 

    </queryDef>); 

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

var some_variable= <customer

                                      xtkschema="ram:customer"

                                      _key="@firstName"

                                      _operation="Update"

                                      city = {record.city}

                                      firstName={record.firstName}

                                      />;                                                               

xtk.session.Write(some_variable);

1 reply

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
August 21, 2019

Hi Ramprakash,

It can be that your query doesn't return anything so there is no update.

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="city"/>

     </select> 

    </queryDef>); 

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

var some_variable= <customer

                                      xtkschema="ram:customer"

                                      _key="@firstName"

                                      _operation="Update"

                                      city = {record.city}

                                      firstName={record.firstName}

                                      />;                                                               

xtk.session.Write(some_variable);

Terms & ConditionsAccessibility statement

Loading footer...