Change cmdb_ci.short_description in HTM

obrochard
Tera Contributor

‎11-10-2023 03:54 AM

I try to change Change field short_description in cmdb_ci table from String to HTM

 

System Definitions > Table

filtre : name=cmdb_ci

obrochard_0-1699617203042.png

 

It's work fine. 😀

 

I want to be sure that next upgrade will not failed by this transformation

 

0 Helpfuls
  • 175 Views
1 REPLY 1

Tai Vu
Kilo Patron
Kilo Patron

‎11-10-2023 04:07 AM - edited ‎11-10-2023 04:08 AM

Hi @obrochard 

Let's have a look to the below kb, so you will have a better approach.

KB0966730 -  Changing field type or column datatype

 

Changing the data type of column/field

Generally, It is highly recommended to avoid changing the type of a column. Experience has shown that a better approach is to create a new column with the new data type and copy the data from the old column to the new column

Steps to follow to change the data type

1. Create a new column with the new datatype

2. Copy the data from the old column to the new column

3. Rename the original column label

This is all so as not to break customer customizations and avoid loss of data.

 

 

Cheers,

Tai Vu

0 Helpfuls