Database

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