/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Need some help copying parent ticket category to child ticket

05/15/2018 653 views
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

Comments

  • In the rule select run the update query.

    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

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login

Share

 
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