ACL error when using Configure function field for reports

Mike_G5
Tera Contributor

I am receiving the following error when trying to use the "Configure function field" option available in the new UI Report Designer:

"Access to this content denied based on report_view field ACLs."

The report source is sc_task table.  The report works without any errors if the "Configure function field" is not used.  

I have reviewed the report_view ACL's for the sc_task table and did not see any conditions that should prevent access.  

I am using the Configure function field to calculate the duration of a task being opened then closed.

 

Any idea how to determine what is causing this error?

See Attachments:

 
11 REPLIES 11

Hemanth M1
Giga Sage
Giga Sage

Hi @Mike_G5 

 

Are you using any additional group by?? 

Can you please check if you have any field level report_view type ACL.

 

The error says field level ACL is restricting (this happen when acl applied on field level and if you use that field as "group by")

 

Please confirm.

 

Thank you,

Hemanth

 

Thank you,

Hemanth

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Hi @Hemanth M1 

I do not have any additional group by.

I tried running a debug for the security rules (see screenshot) below, I am not sure how to locate the ACL that needs to be addressed for this error.  Can you please advise how to proceed to correct this issue?

Hi @Mike_G5 ,

 

HemanthM1_1-1689778912959.png

 

Can u click on the above ACL and see if its restricting, looks like report_view type and applied on the function field.

Deactivate this acl and check once.

 

 

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Hey,

I am facing same issue, with incident table report. Have you resolved this or got any solution?

 

Regards.