Use function field with aggragation on report

Philippe
Tera Contributor

Hello,

I have the common message of ACL limitation when running a report:

"Access to this content denied based on report_view field ACLs."
 
As you see in the screenshot, I want to configure aggregation on Task > Incident > Outage duration, which is a function field (between two custom dates and not OOTB dates). The documentation said "Function fields in reporting do not support dot walking." but I am not sure if my use case is concerned by this rule.

I tried adding an ACL with report_view on incident.u_rpt_outage_duration but it does not change anything which could be normal if I am in the exception of usage explained by the documentation.
 
If any of you have an idea, please,
Thanks
1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

You are dotwalking to the outage duration field, so yes, this rule applies, I'm afraid. Can't you report on the incident table, where you can just do it on the field without dotwalking?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

2 REPLIES 2

Mark Manders
Mega Patron

You are dotwalking to the outage duration field, so yes, this rule applies, I'm afraid. Can't you report on the incident table, where you can just do it on the field without dotwalking?


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

I have the same error even on Incident