Removing the Subject Prefix in Confluence Emails
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
This is an untested database modification. While it probably won't cause any problems, it is very important to back up your database before attempting this. Please also be aware that if problems do occur with mail afterwards, you may need to roll back this change.
Confirm that your SMTP server details that you want to change are fully correct (except for the Subject Prefix).
Shutdown Confluence.
Back up your database
Find the bandanaid of the SMTP server that you'd like to change:
1select * from bandana where bandanakey like '%atlassian.confluence.smtp.mail.accounts%'You can check the value stored in the bandanavalue column to confirm that this is the SMTP server you are looking to change if you have multiple set up for your instance.
Edit the value of the <prefix> tag that is stored in the bandanavalue column to whatever you like.
update the database with this change:
1update bandana set bandanavalue = 'MY_COPY_PASTED_ENTRY' where bandanaid = BANDANA_ID_VALUE_FOUND_IN_SELECTRestart Confluence and send a test email to confirm that the change has taken effect.
Was this helpful?