Retrieve user acceptance details of announcements from database into Bitbucket
This article explains how to view the details of user acceptance of announcements created using the Announcer for Bitbucket Server app by retrieving them from the database.
Instructions
- Log into the database.
Use the scheme that you are using for Bitbucket instance.
All the notifications accepted by users are stored in the AO_CE9B14_NOTIF2_USER table.Compose a SELECT query to retrieve the list of notifications accepted by users from the table, as given below:
select * from AO_CE9B14_NOTIF2_USER,AO_CE9B14_NOTIFICATION_USER;
This query displays the user acceptance of announcements list in your Bitbucket instance.
- No table captures the list of notifications that were not accepted by users.
- Ensure to not run CREATE/UPDATE/DELETE operations that may impact the data at the application level.
- MySQL is the database used in this example.