/bundles/itninjaweb/img/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   [ - ] Hide 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
Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity

Answers

Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share