Changing entity schema at run time
Application Type
Reactive

We are importing excelsheet data in the OS entity, at present the fields in entity are mapped as per the incoming excelsheet columns.

But according to ask the incoming excelsheet columns can change in future, we may add new columns, rename existing columns.

So we want to know, if this is possible, to add new fields or rename fields in OutSystems entity at run time.

Also want to know, if we have an external database, can we add column to an existing table. 

Solution

Hi Pushkraj,

Adding/updating data model at runtime is never recommended. As per my understanding, Outsystems platform does not provide any such feature to do so. These are the development activities which requires planning, implementation and testing. Changing your data model will surely break your existing application. So, whether it is outsystems DB or external DB  you can perform any updation in data model in development phase only.

Thanks, hope it helps. 

Ambar

mvp_badge
MVP
Solution

Hi Pushkraj,

It is not possible to dynamically alter OutSystems-managed database Entities. It would also not make sense, as there is also no way to dynamically use Entity Attributes (e.g. by specifying their name as Text) - all Attribute use is through statically typed code.

Solution

Hi Pushkraj,

Adding/updating data model at runtime is never recommended. As per my understanding, Outsystems platform does not provide any such feature to do so. These are the development activities which requires planning, implementation and testing. Changing your data model will surely break your existing application. So, whether it is outsystems DB or external DB  you can perform any updation in data model in development phase only.

Thanks, hope it helps. 

Ambar

mvp_badge
MVP
Solution

Hi Pushkraj,

It is not possible to dynamically alter OutSystems-managed database Entities. It would also not make sense, as there is also no way to dynamically use Entity Attributes (e.g. by specifying their name as Text) - all Attribute use is through statically typed code.

Hi Yogi, 

I  used mysql external database before, and the best practise are:

# do not change the winning team (column name)

# if you don't need it anymore, let it be

# if you want a new one, just add the new column at the end of the entity with a new column name.

else it will be an IT risk.

OS keep versioning in database, so by changing the column name will complicated its tasks. So, hekp OS to do something simpler. What is in a name?

regards

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.