Syntax errors on extremely basic SQL queries
Hello,
I am looking into creating custom ticket rules for our one queue, however when trying to develop the SQL, even extremely simple SQL queries like "select ID from HD_TICKET" will throw a syntax error when I click on "View Ticket Search Results".
Are the database field names different from the example given, or is there some setting I need to configure, or what?
Thank you,
Answers (2)
Doesnt work usually because your rule has variables or commands relative to the current ticket (run on save).. I would suggest you connect a sql editor to your kace db to play around.. but I have to tell you, after 2 yrs of learning kace rules, it takes a ton of time to understand how kace does sql rules.
I have written a lot of custom ticket rules and I almost never use the View Ticket Search Results link. I agree with barchetta, use a tool like MySQL Workbench to test your queries.
I have noticed on some tables that you must include the table in the prefix of the select query? No idea why but you might try this....
SELECT HD_TICKET.ID
FROM HD_TICKET
I am also curious if this works for you as I just ran into this yesterday when writing some custom reports. - cstewy 1 year ago