AnsweredAssumed Answered

need help on re-assigning  action item

Question asked by rg2027 on Nov 29, 2010
Latest reply on Dec 7, 2010 by Dave
I have a custom object which would have attributes like ActionItemID,ExistingAssignee,newAssignee
On saving this object I need to assign the action item to the newassinee

I tried executing below query but action item is not seen in the action item list of the new user.

update niku.CAL_ACTION_ITEM_ASSIGNEES
set assignee_id = 5089673, last_updated_date = GETDATE()
where cal_action_item_id = 5012014 and assignee_id = 5001436;

I will get below data in the gel script
ActionItemID = 5012014
OldassigneeID=5001436
NewassigneeID=5089673

Do I need any other data inorder to show up the action item for new assignee.

Please help me solving this requirement

Thanks in advance

Outcomes