How to remove the email prefix in JIRA SMTP server configuration

Still need help?

The Atlassian Community is here for you.

Ask the community

The content on this page relates to platforms which are not supported. Consequently, Atlassian Support cannot guarantee providing any support for it. Please be aware that this material is provided for your information only and using it is done so at your own risk.


  1. First step is to identify the mail server ID in the database, by running the following query against JIRA's database:

    select id from mailserver where server_type = 'smtp';
  2. Make a note of the ID returned.
  3. Next step is to update the prefix directly in the database using the ID gathered from the first step:

    update mailserver set prefix = '' where ID=<id>;

    (info) Make sure to replace the <id> in the update statement, with the ID returned from step 1.

    Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  4. Restart JIRA.

There is an existing feature request for this option to be available in JIRA, being tracked here:  JRA-21888 - Getting issue details... STATUS

Last modified on Apr 17, 2017

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.