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
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)