Hi folks.

I have kicked the K1000 into production for the patching and Help Desk. I am trying to get the category as part of the email body but have never been successful. I tried all suggestions which essentially hinged on being able to do a join on the MySQL tables but I could never make it work.

The original thread was here: http://itninja.com/question/email-body-for-ticket&mpage=1&key=𔜏

When we receive a ticket, the category only shows as Category: $TickCategory

I am really wanting to correct that so we can see the actual category.

Anyone want to work through this with me?

Thanks in advance.
--james
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
I believe in the email body the variables need to be in all lower case, so have you tried $tickcategory?
Answered 11/09/2011 by: steelc
Senior Yellow Belt

Please log in to comment
0
That is fantastic - it was definitely just what you thought. Lowercase... I should have noticed that.

One last thing and a real important one is the impact. I would love to have that come in as a part of the body of the email. If you have any suggestion on that, I would definitely welcome it. I already tried Impact: $impact but had no joy.

Thanks again for noticing the $tickcategory.

--james
Answered 11/09/2011 by: jbowes
Orange Senior Belt

Please log in to comment
0
Are you selecting the impact as part of your select statement? Only columns that are included in the select statement will be available as variables in the email.
Answered 11/09/2011 by: steelc
Senior Yellow Belt

Please log in to comment
0
Referring to the other thread you did not have HD_IMPACT.NAME anywhere in your column list so you can't use it in the email. But you did have that table joined so a simple addition of:

select .... , HD_IMPACT.NAME TICKIMPACT, ....

then you could reference it as $tickimpact in the email
Answered 11/10/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity