Change Custom-Field Value ober MySQL

[Antonio D'Errico]

Hello,

i need to update the values in a specific custom field. let assume that the field-name is URL.

this field is used in very issue and contains a link for example like this:

http://ab.programm.alm11.app.domain.net/xxx

xxx is always different so a bulk chang is not possible,

but know i want to change all the values of that custom filed in every issue to:

http://ab.programm.alm12.app.domain.net/xxx

the only difference is the number: 11 is old and 12 is new

best regards

toni

[Peter Geshev]

If you dont have direct access to the db you can use the DB Browser plugin, view the id of the customfield and update the values with an sql similar to the one below

UPDATE "CUSTOMFIELDVALUE" SET stringvalue = replace(stringvalue, 'http://ab.programm.alm11.app', 'http://ab.programm.alm12.app') WHERE CUSTOMFIELD = XXXXX

If you have access to the db you can perform the update statement directly.