---
title: "How to retrieve announcements list from database into Bitbucket"
canonical: "https://support.appfire.com/space/SUPPORT/80881837/How%20to%20retrieve%20announcements%20list%20from%20database%20into%20Bitbucket"
format: markdown
---
This article explains how to retrieve the list of announcements created using the *Announcer for Bitbucket Server* app from the database and display it in your Bitbucket instance.

## Instructions

1. Log into the database.
2. <span style="color: #091e42">Use the schema that you are using for the Bitbucket instance. </span><span style="color: #091e42">All announcements are stored in the </span>*<span style="color: #091e42">AO_CE9B14_NOTIFICATION</span>*<span style="color: #091e42"> table.</span>
3. Write a *SELECT *query to fetch the list of announcements that are created through *Announcer for Bitbucket Server* app from the database table.
  <span style="color: #091e42">The above query diaplys the list of announcements in your Bitbucket instance.</span>

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