Assessment and Assessment Question on Reporting

idevelop4fun
Tera Contributor

Hello I am having an reporting issue that I hope someone can help me with.  I have created and Assessment Metric based on the "sn_grc_profile" table to issue assessments against entities.  When I issue an assessment, the assessment instance does not have any tie to what entity it is related to.  So I thought I would create a new field on the Assessment Instance and have a business rule copy that information from the Assessment Instance Question related list.  For some reason it is not working and was wondering if someone could catch my mistake? 

 

Ilike2develop_0-1697148105564.png

 

Ilike2develop_2-1697148214618.png

 

Ilike2develop_1-1697148130916.png

 

 
1 REPLY 1

ab_2511
Kilo Guru

Hi @idevelop4fun ,

 

Assuming you have configure similar Document ID field on asmt_assessment_instance table as asmt_assessment_instance_question table.

 

You are only updating the value of the "Source" field in your business rule, however the Document ID field needed two inputs in order to set the value.

 

1. Table (ex. sn_grc_profile)

2. sys_id or Record

 

Please create another field with type "Table Name" and add it as Dependent on your custom Field. From BR set values for both fields Table and Record similar as asmt_assessment_instance_question table.

 

 

ab_2511_0-1703741499947.png

 

 

Regards,

Aakash