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,
Answers (1)
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:
SELECT * FROM SOME_TABLE
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!
