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
Introduction:

Restrict updating Workflow Tasks on tickets to only certain users.

Question:

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

Answer:

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 = @root.id OR assignee IS NULL OR (group.[group]group_list.member IN @root.id) 

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.