Impact of changing the field type in ServiceNow

[Anna_Servicenow]

I have a string field in my catalog item called ' Release Id' , I want this to be changed to reference filed. Will this have any impact on already created record? If yes, How to fix it

[Ankur Bawiskar]

@Anna_Servicenow 

yes it will impact on older RITMS.

I had this string variable which had value in it.

I changed it to reference and it started showing this i icon and is trying to find that string in that referenced table

So create a new variable and don't change type for the existing one

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Anna_Servicenow]

I want to pull report for ' Release Id' ,if I create a new field I will have two report columns right. Is there a work around for this?

[Ankur Bawiskar]

@Anna_Servicenow 

yes that's correct.

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Shivalika]

Hello @Anna_Servicenow 

Yes, it will have impact, because string cannot be reference. The solution to this is, first run a fix script on the table that stores values for your variables and update the string to their corresponding sys_id. 

And then change the type to reference. This will ensure that when it changes to reference and searches for sys_id it gets in the record. But if you let it be string only, being a reference field it will search for sys_if and not get it , resulting in blank. 

I have answered this previously as well. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY