Hi experts,
I'm trying to create a database view, to make a report to show all approvals from a specific group, with more informations that sys_approval_group have.
I'm working with 3 tables:
- task
- u_requests_ssc
- sysapproval_group
'u_requests_ssc' is a custom table that stores all requests from a specific catalog. I've created a database view, but when I try to see on report, only shows the number of records, not de data.
I will send attachments to show my setting and the results.
Am I doing something wrong?
@Rufino ,
Please perform below checks and try:
1) Have you added "view fields" mentioned below? if so, please remove fields and try again!
2) Check for the ACLs, you should have read level access on all the tables, please open all the tables and check the list view, just to confirm that you are able to access all the records
If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.
