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 - Getting issue details... STATUS

Environment

From Jira 8.5.x to Jira 8.13.x

Diagnosis

To check the property ID's in the database, use the query below: 

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: 

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: 

SELECT * FROM propertystring WHERE id = 11102;

The query above will return the result below:

Solution

The UPDATE query below can be used to change the "Announcement Banner" text:

UPDATE propertytext SET propertyvalue = 'Announcement Banner text goes here between quotes' WHERE id = 11101;