dot walking to update subject in email template

[dline]

I am looking through code written by someone else that is used within the Service catalog, and I can't find what table the variable is stored in to properly format my dot walk syntax.

My situation is that I have a variable, outr_design_synopsis, that contains a brief description of the request that I want to include in both the subject and in the body of the email notification so that those receiving the request or approval request will have a bit of information provided to them before they open the request itself.

The variable is an item Variable located within the Service Catalog.

I know I'm going to end up hitting myself in the head after this is answered, but can someone tell me how to determine the table that this variable is stored in? After I have that, doing the dot walk is a no brainer.

Thanks in advance,
Doug Line

[dline]

OK, continued digging, and I believe that the table the variables are located in is:
sc_item_variables_task

So I have included the following in the body of the emial notification:
Brief Description: ${sc_item_variables_task.outr_design_synopsis}

Something must still be amiss though as what renders in the email is:

Body of email:

Click here to view request: REQ0010334

Number: REQ0010334
Brief Description:
Due date: 2013-02-23 04:39:55 EST
Opened: 2013-02-22 12:39:55 EST
Approval: Approved

Requested items:
RITM0010410: Design Request
Stage: Fulfillment

Ref:MSGOAR0180519

Do I have to use a glide record? or is my syntax just wrong.

Thanks,
Doug

[dline]

neither above seemed to work. I am beginning to wonder if I am attempting something odd.

[ccajohnson]

It is unclear why this particular variable must be used in the notifications when you can always use fields such as short description.

However, if you need to access the variables, the best method would be to use a mail script within your notification. There is a way to override the subject line using the setSubject() method. Here is a sample mail script that points to your variable:

<mail_script>
email.setSubject("Request for " + current.variables.outr_design_synopsis);
template.print("Design synopsis: " + current.variables.outr_design_synopsis + "\n");
</mail_script>

I hope this is helpful