Why does my published report not show data from dot-walked fields?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2017 06:51 AM
Good day all,
My manager has tasked me with creating a report that a multitude of users can view generated mainly out of Change Request fields.
There is however 1 field (Business Service from the Impacted Services table) that is required to be in the report also.
Because I couldn't dot-walk to the business service field from the change request table, I dot-walked to all the change request fields from the Impacted Services table and in that report view all looks fine.
The problem I am having is that the data for the dot-walked fields disappears when the report is viewed via the published link, is this an inherent existing ServiceNow issue or is it pretty clear that I have done something wrong or not done something??
Many Thanks for any help as soon as is possible
Kind Regards
Steve
- Labels:
-
Change Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2017 08:30 AM
Thanks Chuck,
I have - a table level read ACL for public
- a table * read ACL for public with a condition set to false.
- field level read ACL's for public.
Does this sound about right??
Thanks
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2017 08:51 AM
check the acl's on the field that is not showing...
there are a couple of things to consider here.. when you publish a report it creates a publicly available link.. meaning people NOT logged into ServiceNow can view the report.... so when you are testing you have two cases to test... 1> a user that is signed into Snow... and 2> a user NOT signed into Snow you need to be clear when clicking the link on the published report and looking at it are they logged in or not....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2017 07:40 AM
Hello Steven,
Can you turn on the ACL debugger and make sure that the user has access(READ ACL's) to the referenced table record.
http://wiki.servicenow.com/index.php?title=ServiceNow_Access_Control