A report that shows all closed tickets where the opened for responded after they were closed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 01:36 AM
Hello everyone
I would appreciate any help
i want create report that shows all closed tickets where the opened for responded after they were closed.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 11:04 PM
Hi @Tal5 , I've created something similar to what you are asking for a client recently. To do what you are asking exactly is fairly complicated, but if you want a report/list that will show if a closed ticket has been responded to, that can be done with a simple filter. The caveat on this report is that once the ticket is modified by an agent, it will no longer show on the report, so it's useful for picking up cases that had an email response after they are closed. This will not work if you are looking to extract all cases that had previously been responded to after they were closed, even if they have since been modified.
In my case we created a list for the HR Agent Workspace with the following filter...
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2025 11:10 PM
Hi, please use database view to fetch the report
create a Database View joining:
incident table
sys_journal_field (with condition: element_id = incident.sys_id)
Add conditions in the view:
incident.state is closed
sys_journal_field.sys_created_on > incident.closed_at
sys_journal_field.sys_created_by == incident.caller_idUse this View as the source for your report.