Mirror first Comment on Parent ticket to child tickets

I am trying to set up a way to mirror the first comment on a Parent ticket to mirror onto all the child tickets. 

I was able to work  a Custom Ticket rule to get the titles to change based off the user name. trying to find an article to work with the initial or any comment on the parent ticket to mirror to the child tickets. 

I was able to use https://www.itninja.com/question/have-k1000-use-the-same-title-for-all-tickets-in-a-process

this to allow a name change the parent to affect the child tickets if i can get the initial comment it will save me so much time, 

0 Comments   [ + ] Show comments

Answers (1)

Posted by: Michelle.ashby 1 day ago
Purple Belt

How well do you know SQL? I ask because the way that I figure out this sort of thing is by setting up a table query "report" where I can use:

LIMIT 100; 

And this helps me drill down into the columns and such I need. I know that this super old reference, but this schema has also been helpful to me. But again it is old so be warned it is not totally accurate. But I still find it valuable as it can help point me in the right direction for my "report":
schema_bootkamp.jpg (2690×1867)

Between those two things you should be able to find out how comments are stored (not even sure of what table without researching it myself) and be able to use a similar format to what you have done with the title to update from the parent. 

Hope that helps!

Don't be a Stranger!

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

Sign up! or login

View more:


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