Skip to main content
S
Surekha1-Visitor
1-Visitor
February 14, 2019
Solved

Update a row value in infotable

  • February 14, 2019
  • 2 replies
  • 5808 views

Hi,

    I have data in the info table. I want to replace particular column values(Another service outcome). How can I update it?


var x = me.getData();//x is infotable
for each( var row in x.rows)
{
var y= me.ltime_conv({
ltime: row.LTIME /* LONG */,
lyear: row.DLYEAR /* LONG */});//Another service out come
x.DTIME = y;//Here I'm trying to replace DTIME column values
}

result =x;

 

Regards,

Surekha N.

Best answer by rosharma

either in loop you do

row.DTIME = y;

or simply 

x.rows[0].DTIME = y; // loop out to infotables to update particular row with indexes

 

both ways values are getting updated

2 replies

Z
zyuan15-Regular Member
5-Regular Member
February 15, 2019

I checked through infotable related services in Snippet, there's not update services available, so you can only delete the row you want to change and add a new one, and Sort it if needed.

 

Infotable property in Thing entities is not a good place to store data, and value might lost or changed for unknown reason at some time, so you may want to use Datatable or Stream to store these infotable data, and then you can use the related update services to change row value.

R
rosharma16-PearlAnswer
16-Pearl
February 16, 2019

either in loop you do

row.DTIME = y;

or simply 

x.rows[0].DTIME = y; // loop out to infotables to update particular row with indexes

 

both ways values are getting updated

    S
    Surekha1-VisitorAuthor
    1-Visitor
    February 19, 2019

    Hi @rosharma ,

        Yeah, I have followed the same way. Now it is working.

    Regards,

    Surekha N.

      Terms & ConditionsAccessibility statement