KACE Product Support

It also seems like the way the wizard and default rules have the update queries written, the variable that needs to be set is in the WHERE clause. It might be that I don't understand SQL well enough.

I created a vacation rule and had to change the update query to "set HD_TICKET.OWNER_ID = 0" to get it to work right. The way the wizard wrote it or copying from another default rule it had the variable the update query should be setting in the WHERE clause which seems like it would never work in my mind.

Is this something not right in the wizard or default rules? Seems like that should get fixed if it is. - lmland 11 years ago

Does the select query return the appropriate ticket ids? <TICKET_IDS> is replaced by the ticket ids returned in the select query of the ticket rule. What is the exact error error message? - grayematter 11 years ago

The error message was "error in syntax at line 10 "))". It seems to have resolved itself. I think the problem is when <TICKET_IDS> was empty it meant that the parentheses were around a null value or something. Just ran it this morning on a ticket and it worked. - lmland 11 years ago

that's exactly right: It will error if empty, so in order to test it you must have a ticket that meets the criteria for the KACE inner workings to populate the IDS field. - Wildwolfay 11 years ago

Remember also that the TICKET_IDS variable will correspond to the Select query. Specifically, it will be the last Select value with the label of 'ID'.

So, if you have HD_TICKET.ID, HD_STATUS.ID in your select statement it would correspond to she STATUS. That's one reason thou see things like "HD_STATUS.ID as HD_STATUS_ID"; that keeps HD_TICKET.ID as the ID. - MacDude 10 years ago