We need to update only cmdb_ci_computer table Category and Subcategory fields from string to choice.

[AmadasaniS]

We need to update only cmdb_ci_computer table " Category" and  " sub - category "  field's string to Choice and thos chnages are not effect to the parent table (cmdb_ci)  and any other child tables (cmdb_ci_server,  cmdb_ci_backup_server ) these type of other child table this should not be apples it should be work on only cmdb_ci_computer table , when i opned cmdb_ci_computer table showing like this and using dictionary overide to chnage field type but i didn.t find ant 'Type' related column in the dictionary override , could please provide any one this issue related solution how to reslove  .

[TausifAhmedS]

Hi @AmadasaniS ,

In ServiceNow, you cannot change the data type of a field using Dictionary Override — overrides only allow modification of display-related attributes (like Label, Mandatory, Default value, Reference, etc.), but not the field type itself.

Since the Category and Subcategory fields are inherited from the parent table (cmdb_ci), changing their data type at that level would impact all child tables (such as cmdb_ci_server, cmdb_ci_database, etc.). 

To make these changes apply only to the cmdb_ci_computer table, you can follow this approach:

1. Create new fields on the cmdb_ci_computer table:

   • u_category (Choice)

   • u_subcategory (Choice)

2. Add the required choice values for these new fields.

3. Hide the inherited fields (category and subcategory) on the cmdb_ci_computer form using a UI Policy or Form Layout configuration.

4. Create/Update any business rules, UI policies, or client scripts to reference the new fields (u_category and u_subcategory) instead of the inherited ones.

If this information solves the requirement, kindly mark as Helpful and Accept the solution.

Regards,
Tausif Ahmed.