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,

The users have access to read the fields. They can view them on screen, but the columns are empty when they export the data.

[Ankur Bawiskar]

@Jamsta1912 

Please raise HI ticket and let us know the updates

[Jamsta1912]

Thank you Ankur. The case is with ServiceNow. I will update here with their findings.

[Jamsta1912]

Hi Ankur,

ServiceNow support have suggested disabling List v3. I haven't been able to accept that as a solution though because it would have too much of an impact on the end user experience across multiple teams. It may turn out that this is one of those List v3 quirks for which there is no workaround - other than for an admin to the export the data on behalf of others as required/ schedule a report as admin.

[Ankur Bawiskar]

Hi,

Please check with ServiceNow is there any other alternative for this.

Regards
Ankur