Pull the Inherent Assessment & Residual Assessment fields (UI pages) onto a report

[RushicaB]

Hey,

I am looking to include the following fields on a report but these are not fields on the form but the UI page. So, the fields are not available in the list of columns that can be dragged into a List type report. Is there any way these fields can be included?

[Connor Levien · Accepted solution]

Hey @RushicaB ,

The responses to an advanced risk assessment are stored in the sn_risk_advanced_risk_assessment_instance_response table. If you want to report on the individual questions for both inherent and residual assessments you have to use this table as your source. This is due to the configurable nature of the Advanced risk assessment as it doesn't actually create a field on the Risk assessment table as you could end up with hundreds of columns.

[RushicaB]

Thanks @Connor Levien . This was helpful and I am able to fetch the fields in the report now.