All of rows deleted except an edited row in the Advance Grid

Hi @DEV,YIDE,yoshi 

EditedTable Infotable from the grid contains only edited row values.

For example, if you have 3 rows and you are editing only the 2nd row. EditedTable will contain only the 2nd Row value and if you update the property value using the SetProperties service it will overwrite the previous value which contains all rows. That is the reason for other rows getting deleted.

To overcome this you can create a custom service that takes EditedTable value as input and updates only the affected row in the property without removing other rows.

Sample Code :

I have a dummy InfoTable property with 3 rows in it and name field is the primary key

Script to update only edited value 

if(EditedTable)
{
 // Get property data
 let allData = me.dummyInfoTable;
 
 // Iterate over editedTable Infotable
 for(var i = 0; i < EditedTable.length; i++)
 {
 // get editedTable key value
 var keyValue = EditedTable.rows[i].name;
 
 // Iterate over allData InfoTable
 for (var k = 0; k < allData.length; k++)
 {
 // get allData key value
 var allDataKeyValue = allData.rows[k].name;
 
 // update allData value with edit value if key matches
 if(allDataKeyValue === keyValue)
 {
 allData.rows[k].description = EditedTable.rows[i].description;
 break;
 }
 }
 }
 
 // Update property value 
 me.dummyInfoTable = allData;
 
}
var result = me.dummyInfoTable;

Sample Input :

Updated property value

/VR