Page 1 of 1
					
				To change the custom field type
				Posted: 08 Jan 2020, 11:54
				by shanthini
				Hai,
We have custom field with type 'string' (screenshot.png)
We need to change this type as 'textarea'.But if we change the type , data stored in custom field got deleted.
kindly suggest.
			 
			
					
				Re: To change the custom field type
				Posted: 13 Jan 2020, 15:13
				by cas
				How about using a new custom field?
			 
			
					
				Re: To change the custom field type
				Posted: 20 Jan 2020, 07:09
				by shanthini
				Hai,
Thanks for reply.
Our requirement is to change the existing custom field from string to text area as we have linked this to few of the existing projects. Please suggest is this possible
			 
			
					
				Re: To change the custom field type
				Posted: 20 Jan 2020, 15:20
				by cas
				Can be done but if you want to preserve data, you first need to export it and after the change import it again.
			 
			
					
				Re: To change the custom field type
				Posted: 21 Jan 2020, 06:53
				by atrol
				shanthini wrote: 08 Jan 2020, 11:54data stored in custom field got deleted.
 
There is no data deleted after changing a type.
It's is still stored in table  mantis_mantis_custom_field_string_table" column "value".
After changing the type to "Textarea", the data is read from column "text" 
So all you have to do is to copy the data from column "value" to column "text"
 
			 
			
					
				Re: To change the custom field type
				Posted: 21 Jan 2020, 08:06
				by cas
				Perfect, then it becomes an easy change 
