Columns Blank in Exported Data

[Jamsta1912]

Hello all,

I had a requirement to hide the address related fields on the location table for a subset of location records, for all users except for members of two user groups. I've achieved this with ACLs.

We have a custom boolean field, u_personal_stockroom, on the location table. I have one set of field level ACLs granting read access to the fields, for all users, where u_personal_stockroom = false. I have another set of ACLs granting read access to the fields, only to users who are a member of one of the two groups, where u_personal_stockroom = true.

The ACLs work fine, in terms of what the users can and can't see when navigating the records, viewing reports etc. However, if a user who is not in one of the two user groups views a report on the location table that contains address details, although they can see the address details on screen for those records they're permitted to see, if they export the data to excel the address related columns are all blank. Any thoughts on why this is so, and how I can get around it?

I've noticed, if exporting from a normal list view of location records (i.e. not from an actual report) the columns in the export are NOT blank. I've played around a little with the report_on and report_view ACL operations and have also read about the system property glide.report.add_to_list_supported, but I don't think these are relevant in this case.

Thanks

[Jamsta1912]

Hi Ankur and Bala. Thank you for your responses.
The fields are string fields. Two are custom fields, and the others are base system:

u_address_line_1
u_address_line_2
city
state
zip
country

[Ankur Bawiskar]

@Jamsta1912 

Is this working fine for admins?

refer below link for help

User doesn't see data in the exported spreadsheet

Regards
Ankur

[Jamsta1912]

Hi Ankur,

Admins are not experiencing this issue. I looked at that other community post and it's a very similar problem. But the record level read ACLs we have for cmn_location are the base system one (logged in users can read locations) plus the ACLs that come with Customer Service Managment (with the role sn_esm_user). None of those have the admin role associated so I cannot try the same fix.

[Adam Stout]

I would put in a case with Support.

[Jamsta1912]

Thanks Adam. Yes I think I'll do just that in the morning, unless I or the community have some inspriation over night.