Classic Workflow Task Restriction

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

You can define a data partition restriction for change orders:

table: Workflow_Task
restriction: chg.active=1 AND (assignee=@root.id OR group.[group]member_list.member IN @root.id)

With 14.1 CP1 it is possible to define workflows also for requests. How can I do that?

Environment:
CA ServiceDesk Manager 14.1 CP1, CP2, CP3
Answer:

You have to manually add the Request_Workflow_Task table to the managed tables list manually using SQL or PDM_Load, and then you can write a constraint against that table.
The controlled tables for dp constraints are stored in Controlled_Table (ctab) and you have to add a line for Request_Workflow_Task (cr_wf) in the managed tables list:

TABLE Controlled_Table
 del desc id obj_name persid sym

{ "0" ,"Request Workflow Task Table" ,"16405" ,"cr_wf" ,"ctab:16405" ,"Request_Workflow_Task" }

 It will require a recycle to be enforced.