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
