要約

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 - 課題詳細を取得中... ステータス

環境

From Jira 8.5.x to Jira 8.13.x

診断

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:

ソリューション

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;