Bulk change shortcut URL

Still need help?

The Atlassian Community is here for you.

Ask the community

    

Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.

Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

Jira allows you to create Project Shortcuts, these can be any web address that is useful to the users that are working in a Project.
Commonly, these URL's are often either Jira internal URLs or URL's to a specific domain. In some specific cases if the domain or URL changes for some reason the static link won't be updated as these are manual URLs that are created by the user.

Solution

If these URLs are all to the same domain, it is possible to bulk change them with an update replace directly in the database.
All those links are stored in the table "AO_550953_SHORTCUT", the following update can be used:


update "AO_550953_SHORTCUT" set "SHORTCUT_URL" = replace ("SHORTCUT_URL", 'jira.old.domain.com', 'jira.new.domain.com') 
where "SHORTCUT_URL" LIKE  '%jira.old.domain.com%';


The update will replace all URL's that start with jira.old.domain.com replacing only the domain section with jira.new.domain.com
(info) It is required to restart Jira after performing the update.



Last modified on Apr 7, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.