I have a client who's Incident form has a reference field to the kb_knowledge table.
One of the users has many roles, and among which are itil, knowledge_admin and report_admin. She is able to run a report on the knowledge table and see the data (e.g. Short Description) without issue. The problem I am trying to fix is that when she runs a report on the Incident table, and adds columns by dot-walking to the knowledge table through the Knowledge Article reference field on the Incident form, she can't see the data. She is able to add the columns without issue, but all the columns are empty.
I enabled the security debugger, and impersonated the user, whichconfirmed that the user does have "report_on" ACL access to the Knowledge table.
Note: as admin, I have not issues viewing the columns. so it seems pretty likely that it is an ACL issue.
Here are screenshots to show what I am talking about:
Dot walking from Incident, the fields are blank.
Directly from the knowledge table, they are not blank:
