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:
- For each question type (choice, number, checkbox, percentage, date/time, multi-select, etc.), which field(s) in asmt_assessment_instance_question store the responses?
- 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.)?
- 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
