How to update an Application Link URL manually
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.
There are times where you'll need to update an Application Link in Confluence 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.
- Shut down Confluence if it's running
- Perform a full database backup
Run the following query to identify your application link:
SELECT * FROM BANDANA WHERE BANDANAKEY LIKE 'applinks%url';
- For each application link you'll have two records - one for the application link URL and one for the display URL - for example:
You will need to update the URL to your new address, using the ID you gathered in Step Three (3):
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.
UPDATE BANDANA SET BANDANAVALUE = '<string>newURL</string>' WHERE BANDANAID = xxx
Replace newURL with the new Application Link URL, and replace xxx with the ID of the rows you wish to update from Step Three (3)
- Restart Confluence, and verify that your application link is correctly pointing to the new instance.
Was this helpful?Yes Provide feedback about this article