Populated field in a report is exporting as blank

SeanM1
Tera Guru

‎02-22-2016 04:24 PM

Hi all, I have what I assume is a simple issue that I just can't work out.

I have a report based on the sc_task table and I have dot walked to the sc_request table to pull in the 'Requested By' field (it's a standard reference type based of the sys_user table)

When I run the report the the fields are populated as expected.

find_real_file.pngfind_real_file.png

But when I export it to excel or pdf the 'Requested By' is blank

find_real_file.png

What am I missing, your help would be appreciated

Preview file
12 KB
Preview file
13 KB
Preview file
27 KB
0 Helpfuls
  • 3,332 Views
15 REPLIES 15

Evan Clay
Tera Contributor

‎01-09-2024 11:44 AM

For fellow web searchers trying to find the most recent fix for this:

For Rome and onward, there is a permanent fix available.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0793259

Workaround
This problem is fixed in all currently supported releases. Review the Fixed In section to determine the latest version with a permanent fix your instance can be upgraded to.

NOTE: For upgraded instances to enable the fix, set to true the system property glide.script.partial_record_materializer.enabled. Test the property change in sub-prod instances before enabling in production, as there may be a slight performance degradation after enabling.

This property allows the materialization of partial records, which are GlideRecord objects that present unresolved columns for their stored data rows. Partial GlideRecords are created when joins to another table are done with only part of the target table row is returned. On the platform this shows as a dot-walked
table normally specified by the user via the UI.

Related Problem: PRB1329985

0 Helpfuls