topic Re: Unable to delete Row from infotable with function myInfoTable.RemoveRow(rowIndex); in ThingWorx Developers

Unable to delete Row from infotable with function myInfoTable.RemoveRow(rowIndex);

MA8731174 — Mon, 29 Apr 2024 13:48:50 GMT

let entry = Things["Allied_Entries_SCW1.DT"].GetDataTableEntryByKey({key:"1713786015000SCW1E-AS-02"}); logger.info(entry.rows); entry.rows[0].versionData.RemoveRow(0);

versionData is an infotable but i am still not able to remove the row with its index. As you can see this is an infotable why i am unable to remove it. any idea please?

<========================================================================================================>

FURTHER TESTING

I am removing row and updating that entry with removing that row but it is removing row at run time means i get what i want as an output but it not updating it in datatable. Anyone has an idea?

Re: Unable to delete Row from infotable with function myInfoTable.RemoveRow(rowIndex);

Sathishkumar_C — Mon, 29 Apr 2024 14:15:06 GMT

You need to update again into the data table.

Allied_Entries_SCW1.DT

Use following services.

AddOrUpdateDataTableEntry() or AddOrUpdateDataTableEntries()

Re: Unable to delete Row from infotable with function myInfoTable.RemoveRow(rowIndex);

MA8731174 — Tue, 30 Apr 2024 05:55:09 GMT

I am already doing this but it is not working as it returns the result on runtime correct but not updating the entry into datatable.

@PaiChung any idea?

Re: Unable to delete Row from infotable with function myInfoTable.RemoveRow(rowIndex);

MA8731174 — Tue, 30 Apr 2024 06:13:55 GMT

I got a solution for this issue which is very weird and i could not understand that why it is behaving like that but at least i have a solution now.

let entry = Things["TestBench_Entries_SCW1.DT"].GetDataTableEntryByKey({key:"1709109105000SCW1E-SCW-EMT-06"}); let values; let newVersionData = entry.rows[0].versionData.RemoveRow(9); // this wil remove the row and then idk how we are updating the entry in the datatable but it is working actually values = Things["TestBench_Entries_SCW1.DT"].CreateValues(); values.entryTimeStamp = entry.rows[0].entryTimeStamp; // STRING [Primary Key] values.Location = entry.rows[0].Location; // INFOTABLE values.Position = entry.rows[0].Position; // DATETIME values.entryDate = entry.rows[0].entryDate; // STRING values.status = entry.rows[0].status ; //"SCW1Phase4";// STRING // To change the status of the main entry values.tinNumber = entry.rows[0].tinNumber;// STRING values.versionData = entry.rows[0].tinNumber; //entry.rows[0].versionData;// STRING Things["TestBench_Entries_SCW1.DT"].AddOrUpdateDataTableEntry({values:values}); result = entry;