Track the Work-notes on change request table in Report

[Service Manager]

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

[Patrick Fedigan]

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,

[The SN Nerd]

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

[Service Manager]

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

[The SN Nerd]

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.