Using the DATACONST table for Auto Mail Subject format
| ♥ 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 |
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: 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 Marked as spam
 Posted by David Hall (Questions: 1, Answers: 216) Answered on August 2, 2016 2:09 pm
|