nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Which database table holds the email address for project notifications?

Vikki Short

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

Accepted answers

Gaston Valente_dzz4x1

Vikki,

The table is [SCHEMANAME].propertystring

All comments

Gaston Valente_dzz4x1

Vikki,

The table is [SCHEMANAME].propertystring

Vikki Short

Thanks Gaston

Matt Doar_tzgiej

I found all projects with a From address set using

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

Laurent Delplanque

select ps.propertyvalue as 'notificationEmail', p.pkey
from propertyentry pe, propertystring ps, project p
where pe.property_key='jira.project.email.sender'
and pe.ID = ps.ID
and pe.ENTITY_ID = p.ID
and ps.propertyvalue is not NULL
;

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-development