Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
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.
Solved! Go to 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
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.
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