Using the DATACONST table for Auto Mail Subject format

  • Questions
  • Using the DATACONST table for Auto Mail Subject format
Question ID: 107043
0
0

I am currently trying to mimic our "AUTO_MAIL_SUBJECT_FORMAT" field that we have in the table DATACONST in one of our other Production Projects. Unfortunately, I am having trouble with the 3 values (BG_PRIORITY, BI_BUG_ID, BG_SUMMARY) all populating. I can only get it to retrieve 2 out of the 3 and can’t seem to get it correct. Can you please assist?

Marked as spam
Posted by (Questions: 201, Answers: 2)
Asked on August 2, 2016 1:45 pm
18 views
Answers (1)
0
Private answer

Here is how you need to modify your DATACONST table:

INSERT INTO DATACONST (DC_CONST_NAME, DC_VALUE) VALUES (AUTO_MAIL_SUBJECT_FORMAT, ?BG_PRIORITY ISS#?BG_BUG_ID - ? BG_SUMMARY)

![alt text][1]

The resulting email will have the following subject line:
![alt text][2]

where 5 was the Priority, 48 was the Bug ID & Test For Automail, This is just a Test was the Summary.

[1]: /storage/temp/466-dataconst-table-result.png
[2]: /storage/temp/467-auto-mail-subject-line.png

Marked as spam
Posted by (Questions: 1, Answers: 214)
Answered on August 2, 2016 2:09 pm