Which database table holds the email address for project notifications?

Vikki Short September 1, 2017

Hi

Can anyone tell me how to find the project email address in the JIRA database (in the UI it is the one found in the "Notifications" section on the "Summary" page for a project).

 

Thanks

Vikki

2 answers

1 accepted

1 vote
Answer accepted
Gaston Valente
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 1, 2017

Vikki,

The table is [SCHEMANAME].propertystring

Vikki Short September 4, 2017

Thanks Gaston

0 votes
Matt Doar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 7, 2021

I found all projects with a From address set using

select * from propertyentry where property_key='jira.project.email.sender';

Suggest an answer

Log in or Sign up to answer