/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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