/build/static/layout/Breadcrumb_cap_w.png

In the following SQL statement, what does the < > operators do?

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>


1 Comment   [ + ] Show comment
  • Thx so much Nico_K. I'm somewhat of a newbie with SQL and my thoughts were leaning that way, but needed validation. - kgilbert 6 years ago

Answers (1)

Answer Summary:
Posted by: Nico_K 6 years ago
Red Belt
0

Top Answer

<CHANGE_ID> needs to be replaced by the ID you want to use. Take this as a variable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ