How do I write a custom SQL rule to pass the comments from a parent in to the comments of a child?
I have seen this question asked as a follow up question in several places on here but it is never really answered. I have a process for new hires that creates a parent and several child tickets. I need to be able to pass the comments (im already passing custom fields) from the parent ticket to each child ticket (preferably on ticket save).
In other words, i need to be able to see each parent ticket comment in the comments section of each child ticket. I'm very limited in my SQL ability so an explanation of any code provided for this issue would be greatly appreciated.