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?
Changing values of custom fields
Moderators: Developer, Contributor
-
- Posts: 66
- Joined: 11 Jan 2024, 19:32
Re: Changing values of custom fields
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:
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';