Populated field in a report is exporting as blank

[SeanM1]

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.

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

What am I missing, your help would be appreciated

[SeanM1]

jued0001 That is brilliant and detailed information, which helps a lot.

Thank you.

[keepintouch_kir]

Hi Jude,

Thanks a lot for posting the response. Could you help with which ACL are they referring to ? Please post a screenshot of the ACL. I want to check in my instance if i can tweak & get this to work without having to use the property.

Warm Regards,

Kiranmai

[Shane J]

This is my custom 'read' ACL script, but it's what they were referring to (and couldn't give me an alternate way to do it):

var answer = (gs.hasRole("itil") || current.request.opened_by == gs.getUserID() || current.request.requested_for == gs.getUserID() || current.request.requested_for.manager == gs.getUserID() || current.request.opened_by.manager == gs.getUserID() || current.watch_list.indexOf(gs.getUserID()) > -1);

[keepintouch_kir]

Hi Jude,

Is this fixed in Jakarta by any chance?

Warm Regards

Kiranmai

[Shane J]

I don't know, we're still using Helsinki.