Unable to view data in report

[RaginiP]

I'm trying to create a report on the sys_outbound_http_log  table,but this table is not available in the reporting source list. To overcome this , I have created a database view including this table. However ,when I try to generate the report, no data is displayed.

has anyone faced a similar issue or know how to make the data visible in the report?

[Renat Akhmedov]

Hi RaginiP,

The "sys_outbound_http_log" is an internal log table, it is subject to strict ACLs and is not offered as a reporting source by default.

Go to System Security - Access Control (ACL),

Create a new ACL:

Type: record

Operation: read

Name: sys_outbound_http_log

In the Requires role field, add the role you want to grant access to the data (for example, report_viewer).

Make sure the Condition and Script don't restrict access.

Save and clear the cache (сache.do)

Now users with this role will be able to read the table directly (and therefore build reports based on the Database View, if the view uses this table).

Hope it will help, and if it helped you, please mark this answer with a thumb up,

Best regards,
Renat Akhmedov