Change the field type from check box (true/false) to choice field (TRUE and FALSE) on cmdb_ci_appl.

[Mad3]

Hello Community!

I have requirement to change the data type from check box (true/false) to choice field (TRUE and FALSE). Here As attached in attachment field is dot walking from cmdb_ci table. I have tried creating new choice field to replace and tried to give same back end name to new field. So I want to make inactive the field from cmdb_ci_appl table and change back end name also .
I think to make such kind of changes (make inactive) on cmdb_ci table is not recommended since the same variable may use in some of other tables as well. 

I need to give same back end because (as exist field's has) this might used in integration and scripts as well. So to map the data need to give same name.

Requirement: 
--> Field "Integrated with SSO" the field type should be updated to Dropdown and values should be "TRUE" and "FALSE". (This is custom field not able to change back end name as exist field has.).

--> Field "Vendor Support Available" the field type should be updated to Dropdown and values should be "TRUE" and "FALSE". (This field is dot walking from cmdb_ci table. created new field not able to change the back end name as exist field has.)

If possible I would request to help with solution If not provide me an alternative solution.

Thanks in advance.

[Ankur Bawiskar]

@Mad3 

you can't change the column name of OOB field.

See if you can change the type from Boolean to String with choices

Simply delete that field if you haven't migrated the update set to UAT

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

[Uncle Rob]

Really curious why this is needed.  For the giggles I created a table with both checkbox field for true/false and a choice field with true/false values.  For each record in the table I set both the checkbox and choice fields to "true or false" such that they matched.  Then I ran a script to output their values record by record.
Values were exactly the same.

[Mad3]

Hi @Uncle Rob ,

Thanks for the reply!

Here the requirement is to make the fields mandatory, So when make mandatory user is should have choice to select from drop down. Since they are check box field types there is no chance to unchecked for both fields.

What is your recommendation here for this kind of requirement.

[Uncle Rob]

Ok... so what they want is something that's got no default value, but must be explicitly chosen as true / false?  

Is this something that's just some random user's preference?  Or do they have a demonstrated history of bad data because of the data type?