Database
- Boris Berenberg - Atlas Authority (Unlicensed)
- Anton Melnyk (Unlicensed)
We store data in the following tables. This isn’t intended to be used commonly, but we try and provide SQL queries here to help with troubleshooting steps.
"AO_F9C6CD_NAFJ_SMDC" -- Store config for ‘Send Email from Issue’ (Not using)
"AO_F9C6CD_NAFJ_EVENT" -- Store event info (Not using)
"AO_F9C6CD_NAFJ_ETH" -- Email Templates Themes (old)
"AO_F9C6CD_NAFJ_ETK" -- Email Template keys
"AO_F9C6CD_NAFJ_N" -- Notifications
"AO_F9C6CD_NAFJ_ET" – Email Templates
”AO_F9C6CD_NAFJ_IC” – Information Collection
”AO_F9C6CD_NAFJ_PPP” – Permissions per Project (Not using)
”AO_F9C6CD_NAFJ_WH” – Web Hooks
”AO_F9C6CD_AUDIT_LOG” – Audit Logs
AO_F9C6CD_NAFJ_N" -- Notifications
-- Search for Notification IDs based on a hardcoded To email
select "ID","RECIPIENT_EMAILADDRESS" from "AO_F9C6CD_NAFJ_N" where "RECIPIENT_EMAILADDRESS" ilike '%WORD%'
-- Move all Notifications FROM one Template TO another
UPDATE "AO_F9C6CD_NAFJ_N" SET "EMAIL_TEMPLATE_AOID" = <TO Template ID> where "EMAIL_TEMPLATE_AOID" = <FROM Template ID>
"AO_F9C6CD_NAFJ_ET" -- Email Templates
-- Search email template bodies
select "ID", "NAME" from "AO_F9C6CD_NAFJ_ET" where "EMAIL_MESSAGE" ilike '%<WORD>%'
-- Search email template by email subject
select * from AO_F9C6CD_NAFJ_ET where "EMAIL_SUBJECT" ilike '%<WORD>%'
"AO_F9C6CD_NAFJ_IC" -- Issue notification counter
-- Search for how many times an issue has been in Notifications
select "RUN_COUNT" from "AO_F9C6CD_NAFJ_IC" where "ISSUE_KEY" = '<ISSUE_KEY>';
"AO_F9C6CD_NAFJ_WH" -- Web Hook configs
"AO_F9C6CD_NAFJ_ETK" -- Email Template keys