A report that shows all closed tickets where the opened for responded after they were closed.

Tal5
Giga Guru

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.

6 REPLIES 6

David Aldridge
Giga Guru

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...

DavidAldridge_0-1746424859629.png

Hope this helps.

Community Alums
Not applicable

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.