Why Reference fields are blank when display in a report via dot walk.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2020 01:20 PM
I have created a reference field in HR Case so I can dot walk to my custom table. Records are inserted to my custom table whenever HR Case is created. And this works fine.
However, when I create report against HR Case to display fields from my custom table via dot walk, fields are blank.
Am I missing something?
- Labels:
-
HR Service Delivery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2020 01:35 PM
I don't think the display field functions how you're intending.
I think you can get the control you want with ACL's
https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/contextual-securi...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-05-2020 02:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2020 05:38 AM
Are you referring to the generated ACL's that come with a newly created table? You can touch those, but I think it would be better to create additional ACL's for the custom table. Based on your screenshot it looks like the records from the table are viewable while the fields themselves are not. Thats why they show up in the list view, but the columns are blank.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-07-2020 02:06 AM
Thanks for the input Derek.
I checked the ACL and didn't find any clue to prevent the values to be displayed in the report.
While isolating the cause of this issue, I tried to reverse the dot walking.
I added reference field to custom table and relate this to HR Case.
Generated report against the custom table instead and dot walk to HR Case.
I can see HR Case fields in the report.