Why Reference fields are blank when display in a report via dot walk.

cspra
Giga Expert

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?

find_real_file.png

find_real_file.png

find_real_file.png

5 REPLIES 5

Derek Behunin
Tera Guru

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...

Thanks Derek. I relied on the OOB ACL setup when I created the custom table. Do you think I should touch the system generated ACLs?

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.

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.