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


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 = or chg.requestor =" throws the below error.

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


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

assignee IN ( or chg.requestor IN (