/build/static/layout/Breadcrumb_cap_w.png
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

There are no answers at this time

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