How to update the URL for an application link
Problem
There are times where you'll need to update an Application Link in Jira to use a different Application URL and Display URL without re-creating that link.
Generally speaking, you should not need to re-create the application links unless a specific problem prevents you from using the application links interface.
Resolution
Preferentially, use the UI to edit the application link. Specific instructions are available on the application links documentation page: Link Atlassian applications to work together
If you have issues editing the link on the UI, you have two alternatives:
- You can remove and re-create all of them; Or
You can edit them through the database.
SELECT PS.id, PS.propertyvalue, PE.propertytype, PE.property_key FROM propertystring AS PS INNER JOIN propertyentry AS PE ON PS.id = PE.id WHERE PS.propertyvalue LIKE '%<Insert your remote application url here>%' AND PE.property_key LIKE '%app%';
For example, your remote application's url is :
http://localhost:8090/confluence
, then insert the valuehttp://localhost:8090/confluence
for propertyvalue.Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Please be sure to take a backup of your database before making any changes. We strongly recommend to try these changes in a staging environment before applying them in production.