---
title: "How to retrieve announcements list from database into Confluence"
canonical: "https://support.appfire.com/space/SUPPORT/80879590/How%20to%20retrieve%20announcements%20list%20from%20database%20into%20Confluence"
format: markdown
---
<span style="color: #333333">This article explains how to retrieve the list of announcements created through the Announcer for Confluence app from the database and display it in your Confluence instance.</span>

## <span style="color: #333333">Instructions</span>

1. <span style="color: #333333">Log into the database.</span>
2. <span style="color: #333333">Use the schema that you are using for the Confluence instance. All announcements are stored in the </span>*<span style="color: #333333">AO_13A15E_NOTIFICATION</span>*<span style="color: #333333"> table.</span>
3. <span style="color: #333333">Write a </span>*<span style="color: #333333">SELECT </span>*<span style="color: #333333">query to get the list of announcements that are created through the </span>*<span style="color: #333333">Announcer for Confluence</span>*<span style="color: #333333"> app from the database table.</span>
  <span style="color: #333333">The mentioned query displays the list of announcements in the Confluence instance.</span>

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