Column view access control for list reports
For list reports, the glide.report.add_to_list_supported system property enables the add_to_list access control list. This access control list (ACL) prevents users from reporting on list report columns with sensitive data.
A manager can prevent users from reporting on the Assigned to column
when creating a report, for example. If a table field is restricted for the user, it doesn't
appear in the Available column. Users are therefore not able to
select it in the reports they create.
Note:
When the property is enabled: A user who doesn't
pass the add_to_list access control list for a column sees the restricted columns that are
already included in the report in the Selected column. This user
also sees those columns' data in the report. If the user removes the column from the
Selected column, it’s no longer listed in the
Available column. The user isn't able to select it again to
include in a report.
The add_to_list ACL only applies to the top-level table that the report is based on.
This property is inactive by default. To enable it, navigate to sys_properties.list (System Property table) and set glide.report.add_to_list_supported to true. Admin role required.
After you enable the property, existing reports aren't affected. Columns are only invisible on newly created list reports with fields that you specify as restricted.