Bulk replacement of URL’s in custom fields

[Karolina]

Hi,

I’m moving jira and confluence to new domain.

In content of some tickets we had static URL which were using our old domain. Therefore I done some link replacement directly in database in all places accept "Custom Fields".

I found that those links are in table name customfieldvalue in column “stringvalue”, but there are in form of "shortcut".

i.e. when I put URL https://old.domain/confluence/x/MgKJAgin browser

It will be resolved to https://old.domain/confluence/display/KDG2013/very-long-name

So I can’ just replace in DB
https://old.domain/confluence/x/MgKJAgwith
https://NEW.domain/confluence/x/MgKJAg

Because it won’t work.

Can someone tell me how is this link (shortcut) generated, and how can I replace it for all the tickets which has set up fields with URL’s ?

best regards

Karolina

[Teck-En]

Database system usually has a REPLACE function that you can used to replace partial text in the column vaues. Here's an example of mysql: http://stackoverflow.com/questions/10177208/update-a-column-value-replacing-part-of-a-string

Otherwise, you can export the xml and replace the old domain name with replace function in Text Editor.