Skip to main content
12-Amethyst
December 10, 2020
Solved

Can't update the datashape of an existing infotable (with data)

  • December 10, 2020
  • 1 reply
  • 1356 views

Hi, I've updated the datashape on which is built an infotable called "myInfotable" that contains data (inside a thing), the update consists in adding a column.

I saved and even restarted the thing, but i can't see the new field i added from the datashape, but if i create a new property (on the same thing) for i.e. "myInfotable2" and populate with data, i can see the new field properly!

 

Since I can't delete the previous property because it stores important data, how can i fix this?

Best answer by AlessandroN

I found a workaround and this is:

 

- Create a service on the template or thing that runs this code:

me.appointments_list.AddField({
 "name": "appointment_guests",
 "baseType": "STRING"
});

 

- Run it on the things and the new fields will appear even on the existent infotable properties!

1 reply

AlessandroN12-AmethystAuthorAnswer
12-Amethyst
December 10, 2020

I found a workaround and this is:

 

- Create a service on the template or thing that runs this code:

me.appointments_list.AddField({
 "name": "appointment_guests",
 "baseType": "STRING"
});

 

- Run it on the things and the new fields will appear even on the existent infotable properties!