Restrict role from updating some workflow tasks but not other workflow tasks within a ticket

Document ID : KB000012287
Last Modified Date : 14/02/2018
Show Technical Document Details

Restrict updating Workflow Tasks on tickets to only certain users.


Would like to restrict updating Workflow tasks on tickets to only certain users, how can this be accomplished?


This is accomplished by using a Data Partition Constraint.

The Assignee and/or Group field on Workflow Tasks is required to implement this functionality.

The details of the Constraint are as follows:

Table: Workflow_Task 
Type: pre update 
Where clause: assignee = OR assignee IS NULL OR (group.[group]group_list.member IN 

This constraint restricts users from updating workflow tasks not assigned to them, or a member of the Group assigned, unless the assignee and group field  is null.