How to change Announcement Banner using SQL query (No REST API available)
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
This document shows how to change Jira Announcement Banner text using SQL Query directly in the database.
At this time Jira does NOT have a REST API endpoint available to change the Announcement Banner text or property.
JRASERVER-67199 - Ability to use REST API to update Announcement Banner
Environment
From Jira 8.5.x and later
Diagnosis
To check the property ID's in the database, use the query below:
1
SELECT * FROM propertyentry WHERE property_key LIKE '%alert%';It will return the information below (note the ID column):
The property "jira.alertheader" is the text itself that will be displayed.
This property is stored in the table "propertytext" and from the query above, the ID 11101 must be used:
1
SELECT * FROM propertytext WHERE id = 11101;The query above will return the result below:
The property "jira.alertheader.visibility" is the "Visibility Level" property in the UI.
This property is stored in the table "propertystring" and following the example above, you can get it with the query below:
1
SELECT * FROM propertystring WHERE id = 11102;The query above will return the result below:
Solution
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
The UPDATE query below can be used to change the "Announcement Banner" text:
1
UPDATE propertytext SET propertyvalue = 'Announcement Banner text goes here between quotes' WHERE id = 11101;Was this helpful?