How to access Assessment Responses

[VullankiL]

Hi

I’m working on a requirement to access the submitted assessment responses on a custom portal page. Currently, I’m reading responses from the "asmt_assessment_instance_question" table, and I can see that different question types store answers in different fields, e.g.:

Yes/No question responses -> "value" field
String type question responses -> "string_value" field
Reference type question responses -> "reference_id" field (sys_id)

However, assessment questions can include other types like choice, number, checkbox, percentage, date/time, and multi-select, etc..

Questions:

1. For each question type (choice, number, checkbox, percentage, date/time, multi-select, etc.), which field(s) in asmt_assessment_instance_question store the responses?
2. How do I reliably get the display value for each type (e.g., the label for a choice, the display string for a reference, formatted numbers/percentages, etc.)?
3. Is there a recommended/official way to access the responses (e.g., a single method to get the “human-readable value” regardless of the question type) rather than branching logic per type?

What I’m trying to build:

• A custom portal widget/page that shows the user’s submitted assessment responses with human-readable values (choice labels, reference display names, formatted numbers/dates), grouped by section and in question order.

Could you please help me with the solution for this.

Thank you

[AndersBGS]

Hi @VullankiL ,

My initial though would be why? If a user have responded to a survey, why should the response then be available on the portal?