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

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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)

Environment

Release:
Component: ARGIS