Based on Risk Assessment question Approval should be added to Change Request

[ApoorvaD]

Hi Team,

I have an requirement to add approvals based on Yes selection to the Risk Assessment question in a change request.

Risk assessment questions are added in Risk assessment of the change module(Via plugins). If we calculate change request Risk assessment, where those values are stored? so that based on that i can add an approval in change.

Please refer below attachment

can anyone help me on this.

Thanks,

Apoorva

[Community Alums]

Hi @ApoorvaD 

Once risk assessment is performed by change requester ( navigate to All -change request- risk assessment to look which assessment is get apply for change request). You can verify the his response in related list 'assessment instance' on that change request form.

If you open the this record, we can find the requesters responce on the assessement instance form.

In addition, if you open Assessment group field record, you can verify the related to How the this risk get calculated for change request.

[ApoorvaD]

Hi Nileishpol,

Yes in Assessment Instance it will be stored but how to fetch answered value. I have to check if

Assessment Instance Questions (Verification of change == '2') add approval.
If i open Assessment Instance Questions it will navigate to Risk question where i have created this, Not to the answered one.

Thanks,

Apoorva

[Murtaza Saify]

Where Risk Assessment Data is Stored

1. Risk Assessment Questions and Answers:

   • Risk assessment questions and answers are stored in the asmt_assessment_instance table.

   • Each question and its response are stored in the asmt_assessment_question and asmt_assessment_metric_result tables.

2. Risk Assessment Results:

   • The overall risk assessment result (e.g., Risk Score, Risk Level) is stored in the change_request table in fields like:

     • risk_score: The calculated risk score.

     • risk_level: The risk level (e.g., Low, Medium, High).

3. Risk Assessment Instance:

   • The asmt_assessment_instance table links the risk assessment to the change request via the sys_id of the change request.

---

Steps to Add Approvals Based on Risk Assessment Questions

To add approvals based on a "Yes" response to a specific risk assessment question, follow these steps:

1. Identify the Risk Assessment Question

• Determine the specific question(s) that require an approval if answered "Yes".

• Note the sys_id or unique identifier of the question(s) from the asmt_assessment_question table.

2. Query the Risk Assessment Results

• Use a Business Rule, Script Include, or Workflow to query the asmt_assessment_metric_result table for the specific question and its response.

• Filter the results based on the instance (which links to the change request) and the metric (which links to the question).

3. Add Approval Logic

• If the response to the question is "Yes", create an approval task (e.g., sysapproval_approver record) for the change request.

[ApoorvaD]

Hi,
I do not have "asmt_assessment_question" table in my instance. How to enable it?

Regards,

Apoorva