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_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
-- Search Slack channel by channel's URL select * from "AO_F9C6CD_NAFJ_WH" where "URL" = '<URL>' -- Search Slack channel by channel's Name (since 7.4.0) select * from "AO_F9C6CD_NAFJ_WH" where "NAME" = '<NAME>'
"AO_F9C6CD_NAFJ_ETK" -- Email Template keys
-- Search Display name and key for fields in email template by template id select "DISPLAY_NAME", "KEY" from AO_F9C6CD_NAFJ_ETK where "EMAIL_TEMPLATE_AOID" = <ID>