---
title: "How to retrieve announcements list from database into Jira"
canonical: "https://support.appfire.com/space/SUPPORT/80882472/How%20to%20retrieve%20announcements%20list%20from%20database%20into%20Jira"
format: markdown
---
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.
  The above query displays the list of announcements in your Jira instance.

> ℹ️ - Ensure to not run **CREATE/UPDATE/DELETE **operations directly from the <span style="color: #172b4d">database as these may impact the data at the application level.</span>
> ℹ️ - <span style="color: #000000">MySQL is the database used in this example.</span>