Cannot dot walk to reference fields from Report

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 10:05 AM
Hello,
I am running into an issue after upgrading to Fuji with reporting. Some of the users are not able to dot walk to reference fields from one table to another in a report. One of the Knowledge admins is trying to run a report in the Knowledge Use (kb_use) table and trying to show the article and the article short description from the Knowledge base table. The article number is shown but not the short description. I have checked the ACLs to make sure that he still has access and the acls seem to be correct. I also create a new ACL specific to the short description field of the Knowledge table but did not help. I, as an admin, can see all the fields in the report which leads me to think that they can't see it due to an ACL but the ACLs seem to be fine. Any ideas? Has anyone run into this problem before? Any help is appreciated! I have attached a picture below.
Thank you,
Yeny

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 10:13 AM
Hi Yeny,
Can you turn on the ACL debugger and make sure that the user has access to the referenced table rec.
http://wiki.servicenow.com/index.php?title=ServiceNow_Access_Control

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 10:42 AM
Hi Pradeep,
Yes, the users do have access to the referenced table. The referenced table is the Knowlege Base (kb_knowledge). The report they are running is on the Knowledge Use (kb_use) table. The reference field is called 'Article' and they are trying to show the Short description field so they are using article.shortdescription on the report. The users have read and write access to the knowledge base table so technically, they should be able to see the reference field from the Knowledge Use table but the field appears as blank.
Yeny

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 11:11 AM
Hi Yeny,
Just thinking out loud here...
There are no roles or scripts associated w/ the read roles for the said tables?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 11:34 AM