Cant view certain fields in survey report using asmt_metric_result

[Matt Todd]

Hi all,

Ive made a report to display all survey results on the asmt_metric_result table. It works on my admin account, however when i log in as a user there are fields missing. Particularly instance.task.number, instance.task.short_description, instance.task.opened_by, instance.task.assigned_to. Originally none of the survey responses where there. i added the role survey_reader and it made the survey stuff available such as instance number, metric and string value, but not the related task information. Can anyone help identify what im missing here?

[Matt Todd]

So the instance field links to asmt_assessment_instance. There is an ACL in there called asmt_assessment_instance (Read) however this still does not unlock those fields on the survey for a user. Im super confused what SN wants from me here

[Matt Todd]

Ok i found a permission that makes it work. The role assessment_admin unlocks these fields. That works at least. What i noticed that assessment_read does not work because it is empty. Im not sure how to populate this role with the correct permissions

[patbishop]

I have the same issue, but added the assessment_admin role to the user record did not correct the issue for me. What is odd is that I can see the fields when going directly to the case, but when dot-walked from instance.task it is blank.

What's even more bizarre is if I click on another field, use the arrow keys to select field and then click "enter", I can see the name with a "Security prevents writing to this field" error.