Report to count number of comments and worknotes per user in Customer Service>Case
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2018 03:07 AM
I would like to create a report for counting the number of comments and work notes a user has created in Cases at a certain period of time. Is this possible? If not, is there a workaround where I can export all the list of work notes and comments in Cases.
Labels:
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-19-2018 11:28 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2023 04:33 AM
Hello,
Work Notes and Additional Comments are stored in a table named "sys_journal_field".
You can query this table and filter results based on "Name" and "Element" columns to achieve your usecase.