Dictionary Entry - Function Definition not working

[Navaneeth1]

I have a dictionary entry of type duration for a custom scoped application table. This dictionary entry intends to find the difference between two DateandTime fields. 

I created the same and in the Function definition I entered the code given below:
glidefunction:datediff(resolved_at, opened at)

However, the field shows 0 days 0 hours etc. Is there anything wrong with the code? Does this not work on old/pre-existing records?

The screenshot of the Dictionary Entry is given below: (same image is attached as well)

[tharun_kumar_m]

You're welcome Navaneeth. I'm glad I could help. Thanks for marking my answer as solution.

[Navaneeth1]

@tharun_kumar_m ,

I tried adding this filed on a report and the following error is showing up, do you think these dictionary items need ACL modifications?
Access to this content denied based on report_view field ACLs.

[tharun_kumar_m]

Hi Nananeeth,

Yes, please create a report view ACL for this field or table and add the required roles to the ACL based on the requirement.

Best regards,

Tharun Kumar

[Navaneeth1]

@tharun_kumar_m ,

I created a report view ACL as shown below but it's still not working:

Could you please let me know what could be wrong here?

[tharun_kumar_m]

Hi Navaneeth,

There might be already an report_view ACL preventing the access. Please check for ACL table.*

Table.*, means that you are applying this for all rows/fields on that table which don't have their own specific table.field ACL.

The ACL in the below screenshot applies for all the records in the table which don't have a separate field level ACL applied.

Also please check if there is any table level ACL. (table.none) 

If there is any table.* or table.none please alter their roles to view the report.

Note:  Admin Overrides option permits users with the admin role to automatically pass the permissions check for this ACL rule regardless of what script or role restrictions apply. However, the nobody role takes precedence over the Admin Overrides option. If an ACL is assigned the nobody role, admin users cannot access the resource even when the Admin Overrides option is selected. 

If my answer has helped with your question, please give a thumbs up.

Best regards,

Tharun Kumar