function field on report not visible

[El Cuchi]

Hi All,

i trust this email finds you all well.

situation

i created a report to show how long i takes each group to approve their changes. For this purpose i created a function field that calculates the date it was approved - date approval was created. The report works great in dev.

ISSUE

I dont have admin role in PROD, so when it comes to run the report an error msg is displayed.

"access to this content denied based on report_view field ACLs"

The report is shared to itil role and i have it for sure.

The interesting part is if I change the "aggregation" field works fine, however, if i changed it back to the function field i cerated i get the error.

Snow support is saying that i need to create 2 ACLs (read & report_view) for the newly created function field, so i can removed the error message. Furthermore, every time i create a new function field i need to create an ACL for it.

is this correct? it sounds inefficient to me.

regards,

max

[AshishKM]

Hi @El Cuchi ,

As the functional field is does not exist in the same database table, for access, system checks functional & contributing both field access.

Refer the below doc, there are 3 scenario given.

https://docs.servicenow.com/bundle/washingtondc-platform-security/page/administer/contextual-securit...

To avoid, creating new ACL, convert the functional field logic to calculated field with additional column. 

-Thanks,

AshishKM