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

[Tracy Davis]

I agree with Paul. We've had requests for this and have not gotten a clear use case besides people want to pull data from SN and paste into excel. I'm not sure why they don't just look in SN and see the real time note updates. We are trying to avoid replication of data in multiple places. I also don't belive it's best practice to report against sys tables, although if you really need to do it then Paul's approach would be the way to go. I'd still try to discourage this as just not best practice though.

[The SN Nerd]

I completely agree.
Managers ask for a lot of reports without understanding how they would use it.
I can't imagine this request have a practical use.

[Service Manager]

I appreciate your response !

but the requirement here is to view the every comment added to change request worknotes in reports.

I could see only last updated by rather than activity in worknotes

However, I added report_on ACL but unfortunately it didn't work.

Thanks

[The SN Nerd · Accepted solution]

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.

1. Navigate to your Database View
2. Open the 'sys_journal_field' View Table
3. Add a View Field 'value' and/or any fields you wish to see
4. Navigate back to your Database View and select 'Try it'
5. If the field is not showing, personalise the list. The field should be selectable.

To allow normal users to report on the table

1. As admin, elevate your Security privileges.
2. Navigate to ACL in the Application Menu
3. Create a new ACL for 'report_on' for your Database Table
4. 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