Running report on asmt_assessment_instance but cannot display assessment answers

[hanaphouse]

I was trying to run a report under asmt_assessment_instance to get:

• All surveys (responded and not-responded)
• If responded, show response.

However, I can't seem to find the right column to show the response. Can some point me to the right direction?

[sachin_namjoshi]

You can report only on completed surveys using asmt_assessment_instance and asmt_metric_result tables.

Task Survey(task_survey) is the table that will help you. It contains fields like whom it is sent to and when it has been completed(for response if survey is taken) or NOT completed based on state value.

Regards,

Sachin

[hanaphouse]

Unfortunately, this table does not contain responses to survey questions as well. 😞

[sachin_namjoshi · Accepted solution]

asmt_assessment_instance table will show in progress survey questions as well which are not yet submitted.

Regards,

sAchin

[priya_jagde]

Hello @sachin_namjoshi ,

We have created some customized questions in assessment form, now after creating demand all questions are not visible on Assessment form, some sections with questions are missing.

We have 12 sections with approx. 5 to 12 questions attached to each sections.

Some sections are visible and some are not visible on Assessment form.

Kindly request you to guide me.

Thanks & regards,

Priya

[Hakim]

I have a similar requirement but one like to isolate the survey's that were rated against our service desk, unfortunately Assignment group is not an available option filter on. Has anyone customized this table to report by assignment groups?

Thanks