Pull answers from Risk Assessment from Change Request

[Cent]

Hi, i got a requirement where if the Business Impact is TRUE, an approval will go to particular users.

My question is how to get the answer from the variable from the risk assessment from Change Request?

[Anand2799]

Hi @Cent ,

Assessment responses are stored in Assessment Instance (asmt_assessment_instance) table, you can filter out records using task, metric type and assigned to fields.

You can get response of specific question in Assessment Instance Question (asmt_assessment_instance_question) table, you need to filter if using the above assessment instance record.

Thanks

Anand

[Prathamesh26]

Hello @Cent ,

Risk assessments are stored in asmt_assessment_instance table and its question and response to an instance is stored in asmt_assessment_instance_question table.

Please raise a Normal change on non prod instance and validate the same.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this question to solved bucket. 

Regards,

Prathamesh

[Nilesh Pol]

@Cent you can verify these answers in "Assessment" related list of change form only, if you opened you can see that will be stored under asmt_assessment_instance table and it will contain assessment used for change request, in below you see all the questions which are stored. 

configuration for change risk assessment: Change request -> risk assessment.

[Cent]

Hi Can you provide a code where i can retrieve the answer from the variable "Will this change have any business impact?"