Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
I have a thing entity which has a set of properties, i want to add a new column to one of the thing properties which is a infotable. For example I have a property named "metatdata" which is a value collection which has a lot of other properties, i want to update one of these properties which is a infotable for example "Data1". This table has 2 columns "column1" and "column2", I want to add a new "column3" here and after that i need to update the values also for the new column.
Thanks.
I would recommend using a JSON property. This way you can update it to any structure without changing the design which may require a restart Thing.
Just remember that when updating the property value (not sure if this still applies to current version) you first assign property value to a temporary variable, update that, and then assign it back to the property.