Where does the Field values store?

[Pallavi65]

Hello All,

I have created a field on cmdb_ci table of Single line text type.

The field is not moved to Prod instance, but it is still present in UAT for 1 year.

Now, I want to move the field to Prod instance also, but here I want to move the fields data also along with the field to Prod.

So, can someone tell me how to do this?

Regards,

Pallavi

[Prince Arora · Accepted solution]

@Pallavi65 ,

Fields can be found in "sys_dictionary" table.

filter Navigator -> sys_dictionary.LIST.

For populating the data from the table you can use two ways:

1) (Best practice and safe way) Export the data from UAT instance and import it into the prod instance like mentioned below:

2) Second way is just capture the data into the update set as mentioned below:

It will capture your record metadata into the update set than you can move data via update set!

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

[Mehta]

In order to move the field from one instance to another, Create an update set and make a small change on field. You make it active false and save it then again make it active true. This way the field will get capture in update set. 

In order to move the data, you will need to move xml of cmdb_ci which is not recommended and data is not captured in update set. Still if you want to move xml then right-click on the list header and click on export XML. An XML file will now be generated and downloaded to your machine.

To import the XML file, you need to head over to the cmdb_ci module and on the column header, you have to right click and select the option for import XML. you will now be taken to this import XML page. From here, you'll want to click on the choose file button and select the XML file that we previously exported, and click on the upload button.