CA Service Management

Hi ,

I need a help. I want to restrict the change order update in certain status ( for ex: CO' s in approval in progress status').

CO's which all are in Approval in progress status should not be updated by analysts, it cannot be edited by analysts.

please suggest best way to achieve this.

Hi,

data partitions is way.

You can create constraint for Change table with Update restricition for specified statuses.

Regards.

hi,

could you please help me with that condition here,

Here is an example:

Thank you very much.. Let me check this in my QC.

Hi, 

Status change has been configured based on work flow task approvals. shall i place this same condition for Workflowtask_request table which has status ' Pending' so that even work flow cannot be edited. please suggest.

Sure you can  If this meets your requriements,

constraint could be:

chg.status != 'APP'

Regards.

Hi, 

Thanks for help. I need one more help on this. I placed below condition to approve workflow tasks where change status in "CAB Review". 

 SQL Translation:

Workflow_Task.status IN ( 'WAIT' , 'PEND' , 'uWIP' , 'HOLD' ) and Workflow_Task.object_id = Change_Request.id AND Change_Request.status ! = 'uCAB'

I actually want the Change orders to be updated which are in CAB Review status and not in other status, please help.

And the Relevant work flow tasks should be updated where CO is in " CAB Review" status and not in other status.

Seems I missed something, if you want to give possibility to update in a single status you can define conditions as:

Table: Change_Request

Type: Update

Constraint: status = '<status_code>'

and the same for workflow tasks, where constraint will be: chg.status = '<status_code>'

please help.

Object name: Workflow_Task.