Can you systematically change the Subject line in a Automail?
Question ID: 109609

Example:  I want to send an automail when the Target Release Date field is populated.  I want the Subject line to state “A Target Release Date has been entered for the Defect” instead of the standard subject line. 

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on June 11, 2020 5:05 pm
Answers (1)
Private answer

Hello Chante', I hope you are doing well. I thoroughly enjoyed working with you all in the ALM class and I hope you have been able to implement lots of the things you learned. The following information comes from the ALM Admin Guide. Please let me know if you have any issue with it. Good luck!

Customizing the Subject of Defect Mail

You can customize the subject line of defect email sent automatically to users, for all projects or for a specific project. For example, you can define a subject line such as the following:

Example: Defect # 4321 has been created or updated - Buttons on print dialog are not aligned

The line can contain the values of ALM fields. To include a field value from the defect that is being sent, prefix the field name with a question mark (?). Field names must be upper-case, as follows:

Example: Defect # ?BG_BUG_ID has been created or updated - ?BG_SUMMARY

You can customize the subject line for all your projects by adding the AUTO_MAIL_SUBJECT_FORMAT parameter in the Site Configuration tab. For details, see Setting ALM Configuration Parameters.

To customize the subject of defect mail for a specific project:

    1. In Site Administration, click the Site Projects tab.
    2. In the Projects list, double-click the project for which you want to customize the email subject line.
    3. Select the DATACONST table.
    4. In the SQL pane, type an SQL INSERT statement to insert a row into the table with the following values:
      • In the DC_CONST_NAME column, insert the parameter name AUTO_MAIL_SUBJECT_FORMAT.
      • In the DC_VALUE column, insert the strings and the names of fields to be placed in the subject line.

For example, type the following SQL statement into the SQL pane:

insert into dataconst values ('AUTO_MAIL_SUBJECT_FORMAT',
'DEFAULT.TESTPROJ - Defect # ?BG_BUG_ID has been created or updated -

The subject line you define is specific to the project, so you can include the project name in the line.

For details on modifying project tables, see Querying Project Tables.

  1. Click the Execute SQL button. The row is added to the DATACONST table to set the email subject.
Marked as spam
Posted by (Questions: 1, Answers: 9)
Answered on June 15, 2020 12:47 am

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top