nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to change a custom field type ?

Vishnukumar Vasudevan

Hi All

I need to change one of my custom fields from 'Text Field' tp 'Free Text'.

Please let me know your suggestions.

Thanks

Vishnu.

Accepted answers

JamieA

As a possibly safer alternative to the above, you can try the copy custom field values function from the script runner plugin. So you could copy Ref Testcase to "Ref testcase new", verify everything looks OK, delete "Ref Testcase", then rename Ref Testcase New to Ref Testcase.

Advantage of this is that you don't need downtime to do it.

All comments

Anni R

http://confluence.atlassian.com/display/JIRA042/Changing+Custom+Field+Types

Vishnukumar Vasudevan

Thanks Deepnight,

I already got this.

"UPDATE customfieldvalue SET textvalue=stringvalue WHERE ID=(SELECT ID FROM customfield WHERE

customfieldtypekey='com.atlassian.jira.plugin.system.customfieldtypes:textfield' AND cfname='Text Field');"

I guess If I try this, all of my 'Text Fields' will be changed to 'Free Text'. My requirement is to change only one of my custom field called 'Ref. Case'.

Any suggestions ?

Regards

Vishnu.

Nic Brough -Adaptavist-

No, that SQL is correct - note the use of the "cfname" in the selection, you need to replace 'Text Field' with the actual name of your custom field that you want to change.

Vishnukumar Vasudevan

Thanks to Both. You are right !!!

I faced another problem. I ran the following queries.

1. 1. UPDATE customfieldvalue SET textvalue=stringvalue WHERE ID=(SELECT ID FROM customfield WHERE
customfieldtypekey='com.atlassian.jira.plugin.system.customfieldtypes:textfield' AND cfname='Ref. Testcase');

2. UPDATE customfield SET CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:textarea', CUSTOMFIELDSEARCHERKEY='com.atlassian.jira.plugin.system.customfieldtypes:textsearcher'
where cfname='Ref. Testcase';

The first one didn't change anything as The table ' customfieldvalue' doesn't have an entry for this field.

I avoided this and ran the second one which changed the field type. Restarted the JIRA, I lost values in this field of all issues. But the type has been chaged.

I guess the problem was I haven't changes the values to 'stringvalue'.

Do we have ant other table which keeps this liek 'customfieldvalue' ? This is JIRA 4.0.1.

Regards

Vishnu.

JamieA

Advantage of this is that you don't need downtime to do it.

Vishnukumar Vasudevan

Thanks Jamie.

Sounds good. But is it possible to move values from one field to another using Jelly Runner ?

I do not prefer installing plugins.

Please offer your opinions.

Thanks, Vishnu.

JamieA

In theory it's possible with jelly runner, in practice not so much, not unless someone has already written how.