/bundles/itninjaweb/img/Breadcrumb_cap_w.png

MySQL Workbench nor KACE likes these characters used around <CHANGE_ID>.  I got the code for this ticket rule from several different ITNinja articles for a submitter response custom ticket rule, but why doesn't it work for me?

LEFT JOIN HD_TICKET_CHANGE ON HD_TICKET_CHANGE.ID = <CHANGE_ID>

Answer Summary:
Cancel
1 Comment   [ - ] Hide Comment

Comments

  • Thx so much Nico_K. I'm somewhat of a newbie with SQL and my thoughts were leaning that way, but needed validation.
Please log in to comment

Answer Chosen by the Author


Answers

0
<CHANGE_ID> needs to be replaced by the ID you want to use. Take this as a variable.
Answered 02/27/2018 by: Nico_K
Red Belt

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

Answers