- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-06-2019 04:22 PM
Need Help in Report
We would like to track / audit every comment added in the work-notes of a change request on change table in a Report.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-11-2019 12:35 AM
I'll re-iterate everything you need to do for completeness.
To add the work notes field to your Database View, you have to add the field to the View Table.
- Navigate to your Database View
- Open the 'sys_journal_field' View Table
- Add a View Field 'value' and/or any fields you wish to see
- Navigate back to your Database View and select 'Try it'
- If the field is not showing, personalise the list. The field should be selectable.
To allow normal users to report on the table
- As admin, elevate your Security privileges.
- Navigate to ACL in the Application Menu
- Create a new ACL for 'report_on' for your Database Table
- Ensure the applicable roles are added to the ACL
If you are still having issues, can you let me know what specifically isn't working?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-06-2019 04:31 PM
Hello,
You most certainly can track work-notes! The table to view is the sys_journal_field table.
Type sys_journal_field.list in the navigator to quickly view.
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-06-2019 04:36 PM
Work notes are only valuable in the context of an individual record.
May I ask what the business reason for this would be?
The database table (Journal Entry [sys_journal_field]) stores Journal Entries is not reportable OOTB.
You would need to create a 'report_on' ACL for that table.
Once enabled, you could filter as follows in a report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-06-2019 04:48 PM
The business would like to track every comment added in the worknotes of Change request on report.
However, I created a database view on change request and Journal entry and When I saw the report, it could see only date and user name under worknotes column but our motive is to view comments too
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-06-2019 06:17 PM
You need to add the Value field on the DB View entry for Journal Field.
By default, DB Views won't be reportable for non-admin so you will need to add the report_on ACL.