Change Custom-Field Value ober MySQL

Antonio D'Errico July 22, 2016

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

1 answer

0 votes
Peter Geshev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 22, 2016

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events