/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   [ + ] 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
Please log in to comment

There are no answers at this time


Answers

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

Share