To change the custom field type

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
shanthini
Posts: 39
Joined: 10 Apr 2010, 12:01

To change the custom field type

Post 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.
Attachments
Screenshot.png
Screenshot.png (30.1 KiB) Viewed 4492 times
cas
Posts: 1611
Joined: 11 Mar 2006, 16:08
Contact:

Re: To change the custom field type

Post by cas »

How about using a new custom field?
shanthini
Posts: 39
Joined: 10 Apr 2010, 12:01

Re: To change the custom field type

Post 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
cas
Posts: 1611
Joined: 11 Mar 2006, 16:08
Contact:

Re: To change the custom field type

Post 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.
atrol
Site Admin
Posts: 8374
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: To change the custom field type

Post 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"
Please use Search before posting and read the Manual
cas
Posts: 1611
Joined: 11 Mar 2006, 16:08
Contact:

Re: To change the custom field type

Post by cas »

Perfect, then it becomes an easy change :wink:
Post Reply