Need some help copying parent ticket category to child ticket
I am looking for some help to copy the category field from a parent ticket to a child ticket using a CTR on Save. I can do this with custom fields, but do not know the database structure to find categories. I am using a K1000 running v8.1.107.
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
update
HD_TICKET CHILD
join HD_TICKET PARENT on CHILD.PARENT_ID = PARENT.ID
join HD_CATEGORY PARENT_CATEGORY on PARENT.HD_CATEGORY_ID = PARENT_CATEGORY.ID - jpack1221 6 years ago