Hi all, Sometime, for troubleshooting purpose, we will do the db refresh from Production database to Dev database. After the refresh, some data are using Production data. So, we have a script which we will execute it after db refresh. One of the script as below: (this sql is to update the Email Handler's Forward Email from Prod email account to dev email account (devjira@abc.com) --set the notification addresses for mail servicesUPDATE propertystring SET propertyvalue = 'devjira@abc.com' WHERE id IN (SELECT id FROM propertyentry WHERE property_key = 'forwardEmail' AND entity_name = 'ServiceConfig' AND propertytype = 5); From table, propertystring, I can see the propertyvalue has been updated to devjira@abc.com. When go to GUI, Log in to Jira > System > Incoming Mail ( we can see lists of Mail Handlers) , at this page, Under Properties, you can see the Forward Email: devjira@abc.com. But, problem now is if you click on Edit (for any of the Email Handlers), click Next (go to second page for mail Handler configuration), at Forward Email, it will state jira@abc.com(Production email account). Can anyone advise any field in database that I miss out to update it? Thanks.

Community
Q&A
Jira
Questions
About changing forward email for mail handler (SQL command)

Microsoft Teams: JIRA Cloud App (Issue Result Columns)

For the JIRA Cloud app, you can create a tab within any Team channel that can display a list of issues based on a pre-defined filter created in JIRA.

Right now, the fields that display appear to be based on a basic stock set (see attached). Are we able to customize what fields display, and if not, is this feature planned?

I would love to have our custom "Status Notes" field display here.

Thank you in advance!

3 answers

1 accepted

0 votes

Answer accepted

My team mate found another field that needed to replace, it is propertystring table (field: propertyvalue). Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Vijay, yes, restart after the post script running (the sql). Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi,

Did you restart JIRA after running the sql script?

Vijay.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Microsoft Teams: JIRA Cloud App (Issue Result Columns)

3 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events