Manual Action Items in Clarity

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

For a manually created Action Item - how is the status updated to CAL_CLOSED by the system? Is there a way to identify who changed the status of the action item having multi assignee in the object based process once the process is completed?

Environment

All Supported Clarity Releases

Resolution

• If the action item is manual, then there is no process in the background, it just gets created.
• The user action of changing the status to Closed will set the cal_action_items.status_code to CAL_CLOSED. 
• You can use the below query to query the action items and the updates on each of them:

          select  i.subject,u.user_name, a.last_updated_date, a.Last_updated_by
          from cal_action_items i, cal_action_item_assignees a, cmn_sec_users u
          where a.cal_action_item_id =i.id
          and u.id = a.assignee_id
          and a.status_code = 'CAL_CLOSED'
          order by i.created_date desc