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