Finance | Project Operations, Human Resources, ...

Rename field in Table

(1) Share

Report

Posted on by Yuji

4,131

Hi,

I found an interesting issue in D365FO. In AX 2012, if we rename a field in a table, for example, CustTable.TrxCustName -> CustTable.TrxCustNameNew. After database sync, the data on the column still exist. However it seems in D365FO, since there is no such field ID on the field anymore, if we rename the field, the values on the field will be completely lost?

Thanks,

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Yuji,

I don't think you will be able to rename the field in D365FO, see what you can do on existing fields.

docs.microsoft.com/.../modify-existing-field

Was this reply helpful? Yes No
Yuji 4,131 on at

Like (0)

Report

Hi Satish,

Actually I provided a wrong example, what we did is all on a custom table and custom fields, not extending any standard tables. But we did rename the field on the custom table, but we found we lost all the data on that column, are you aware of any way we can retain the value?

Thanks,

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

correct. Renaming will truncate data from the field. One option is to create a new field, move data to new field through first deployment. then delete existing field through subsequent deployment.

If it's just in DEV environment, you should be able to do this much easier (no deployment necessary).

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

If you want to rename field create new field, deploy new field and write script to transfer data from old field to new field and then in another deployment delete old field.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If you delete/ rename field with out taking back up of data in another field you are going to loose data

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

In D365FO renaming an object is the same than deleting the original object and creating a new one. So you will lose data.

You need to first deploy the new field, then copy old data to it, and only then deploy a version where the old field is removed. Or even easier, don't rename the field.

Was this reply helpful? Yes No
Joris dG 17,775 on at

Like (2)

Report

The price we pay for no longer dealing with table and field IDs :-)

Was this reply helpful? Yes No
Rudi Hansen 4,075 on at

Like (0)

Report

Another good thing about AX lost :-(

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Yuji,

As mentioned above, if you change the field name or delete the field directly, the data will be lost.

-

But for deleted fields, you can set the configuration key to SysDeletedObjects.

Was this reply helpful? Yes No