How to change field from List Type to Reference Type

[ramesh_r]

Hi All,

I have changed the field from Reference type to List type but now I want to revert this back to Reference type only but the system does not allow me to change the field type, please help me to resolve this issue

Thanks

Ramesh R

[Goutham sai]

Hi,

I believe that you are not allowed to change field type when table already contains data.

In this case you need to empty the table or create a new field.

Note: Best practice is to avoid changing field types on existing fields. Instead, create a new field, migrate the data, and deactive the old field.

Thanks,

Hit Helpful or Correct on the impact of response.

[Chaitanya Redd5]

Hi Ramesh,

I agree with the comment of Goutham, Changing the field type is not recommended by ServiceNow for best practice.

Field type can be changed but it may cause data loss. Please find the below link for reference which was answered by one of the ServiceNow MVP.

https://community.servicenow.com/community?id=community_question&sys_id=d86b4b21db9cdbc01dcaf3231f96...

Also, as I see that you already changed the type of field from reference to list. I would suggest you to move an xml of dictionary record from other instance(e.g-Prod/Test/Sand etc.) if they are still Reference type.

Hope this Helps!

Kindly Mark my answer as Correct and helpful based on the Impact.

Regards,

Chaitanya

[ramesh_r]

Hi Chaitanya,

I have importted the xml value from Test to Dev intance (Afftected instance) but field type is not chaging and alos i tried to chaptrue using using update set and moved but still field type is not changing

Thanks

Ramesh R

[Ankur Bawiskar]

Hi Ramesh,

So what does the xml for the field dictionary contain?

Regards

Ankur