how to update the field in sysapproval_approver table based in change state in change record.

narenreddy
Giga Guru

Hi All,

  I have a requirement that I have two phases of approvals in change management, one is for build and another one is for implementation. I have crated one   field that us Approvals type in sysapproval_approver table so When user requested for build approvals then approval type field should be updated as build in approvals related list and when user requested for implementation approvals then the approval type should be implementation in approval related list. Could you please help me to achieve this.

9 REPLIES 9

Raghu Manchikan
Kilo Expert

HI Narendra,



Write a Business rule on status change in change table and update the particular record in approval table.



Regards,


Raghu


sumeet_n
Kilo Guru

Hi Narender,



Is there any workflow associated with change request? - If yes, how are the approvals getting generated? Depending on this there can be 2 possibilities


1. Approval activity. Where you can specify the field name (Approval type) and its value (Build/Implementation)


2. Script block. Set the approval type value in this block before "insert" of approval.



If no workflow - Check for the server script (BR/SI/UI actions) - search for the point where the approvals are being generated, set the value there.



If this doesn't solve your issue, provide me more information about the approval record generation.


Hi Sumeet,



  Workflow associated with the change request and Approvals are generating through Approvals-group activity, As per my requirement the approval type field should be updated in sysapproval-approver record.


Okay then a BR on sysapproval_approver table will be needed to set the approval type value WHENEVER - approval records are inserted on this table for whom document_id is relevant, by relevant i mean that you can verify if the approval are being inserted for request items, or optionally additionally you may even want to check the catalog item.