How to make workflow tasks viewable only by the assignee of the workflow task and requestor of the change order?

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

Solution:

This requires us to create a data partition constraint on the assignee of the workflow task and the requestor of the change order.

On creating a View Constraint on WorkFlow task with where condition as "assignee = @root.id or chg.requestor = @root.id" throws the below error.

AHD05800: Bad where clause. AHD03106: Where clause results in a Cartesian product

Description:

The above error occurs because the above query tries to create a Cartesian join. In order to avoid use the below query.

assignee IN (@root.id) or chg.requestor IN (@root.id)