How to retrieve announcements list from database into Jira

This article explains how to retrieve the list of announcements created using the Announcer for Jira app from the database into your Jira instance.

Instructions

  1. Log into the database.
  2. Use the schema that you are using for Jira instance. All announcements are stored in the AO_63D3CD_NOTIFICATION table.
  3. Write a SELECT query to get the list of announcements that are created through the Announcer for Jira app from the database table.

    select * from AO_63D3CD_NOTIFICATION;

    The above query displays the list of announcements in your Jira instance.

  • Ensure to not run CREATE/UPDATE/DELETE operations directly from the database as these may impact the data at the application level.
  • MySQL is the database used in this example.