Changing values of custom fields

[acoder2020]

Does MantisBT observe data integrity when we change values of custom fields?

For example, I have a custom field called "Affects Marketing" with possible values `1|0` (1 or 0)

If I change that in the Manage -> Custom Fields to possible values 'Yes|No', will this wreck data integrity?

[acoder2020]

I can answer this myself. Mantis does not bother to update field values in the background.

You'll need to find the id of the field in `mantis_custom_field_table`

Then update your actual value strings with this. Note that the id from above is stored as field_id in the string table:

Code: Select all

UPDATE `mantis_custom_field_string_table` SET value='Does not affect marketing' where field_id=1 and value='0';
UPDATE `mantis_custom_field_string_table` SET value='Affects marketing' where field_id=1 and value='1';