How to change the Reference type filed to list type ?

[Community Alums]

Hi All,

As per my requirement I am trying to change the type of a OOB field from "Reference to List". It throws an error as shown in the below screen shot. is it possible ? can anyone tell me why it is throwing an error..?

Syntax Error or Access Rule Violation detected by database (BLOB/TEXT column 'group_resource' used in key specification without a key length)

FAILED TRYING TO EXECUTE ON CONNECTION 31: /* dev22218001, gs:3C4710B1DBEDF20034C35421CF9619F0, tx:19491035dbedf20034c35421cf9619c1 */ ALTER TABLE resource_plan MODIFY `group_resource` MEDIUMTEXT Syntax Error or Access Rule Violation detected by database (BLOB/TEXT column 'group_resource' used in key specification without a key length)

Invalid update

[kalyan778]

Hi Ayyappa,

I tried in my dev instance,it's working fine for me.

when changing the data type select the view a advanced view in the form.PFA.

Thanks

[kalyan778]

Hi,

Is it possible for you to give the dev instance access?

Thanks

[Community Alums]

Hi Kalyan,

Try below credentials,

Dev22218

credentisl(UID/PWD): kalyan778

[shloke04 · Accepted solution]

Hi,

I can see that your field "group_resource" contains data due to which you are not able to change the field type. You need to make this field data as empty first before changing the type. Once you have cleared this field value for all the records then only you would be able to change the Type.

Hope this helps.Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[Hitesh targe]

i want to change requested by in change request to list. How can we do this. it is not allowing to change even after deleting all the change requests from list view