Insert dynamic comment from custom rule
I'm trying to figure out if it is possible to insert a comment with the result of a SQL query. It appears that the built in "Append comment to ticket" option is just a static/stagnate field that just dumps what's in the box into a comment. What I need is a way for adding a more dynamic comment. For instance:
- I have a drop down menu assigned to Custom Field 1.
- On ticket save, a custom rule checks if there is now data in Custom Field 1.
- If data is there, run update query to add a comment with the results of Custom Field 1 and then reset the field to blank.
Is it possible to add that kind of comment during the update query?