cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Update a row value in infotable

SOLVED
Highlighted
Level 8

Update a row value in infotable

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Update a row value in infotable

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

3 REPLIES 3

Re: Update a row value in infotable

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.

Re: Update a row value in infotable

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

Re: Update a row value in infotable

Hi @rosharma ,

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

Regards,

Surekha N.