Fields missing from database view report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2017 10:23 AM
Hi All,
I see some fields are missing in the report/ list view of database view made on sys_journal table.
In the below picture (admin view) i can see the fields elements ,element id and Value
But for non admin the fields are missing..
Please suggest.
Regards,
Shariq
- Labels:
-
Performance Analytics
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2017 02:10 AM
Element and Element ID is not visible to non admin users by default.
That's why discrepancy in fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2017 02:34 AM
Hi All,
I realized that I had to create to new ACL records on the sys_journal_field table/fields read access with roles (itil and custom role) to make the fields visible.Previously ,there was two custom ACL on the sys_journal_field table where runbook_admin role was required for read access.
But,now i dont understand why the table records were missing/blocked even when the user was provided with runbook_admin,
I mean, the other ACls were simply doing the same job for itil/roles containing user like our previous ACL was doing,i.e giving read access to user having only runbook_admin. Strange isnt?
Regards,
Shariq