search cancel

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

book

Article ID: 54227

calendar_today

Updated On:

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