Update a row value in infotable

[Surekha]

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.

[zyuan1]

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.

[rosharma · Accepted solution]

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

[Surekha]

Hi @rosharma ,

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

Regards,

Surekha N.