Creating a report showing reopened cases

Rodzula
Tera Contributor

Hi

How would one create a report showing all the reopened cases

Many thanks

4 REPLIES 4

AndersBGS
Tera Patron

Hi @Rodzula ,

 

create a report based on the reopen count is greater than 1 - this should solve your requirement.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

@AndersBGS   I don't believe we have Reopen count on HR Cases

David Aldridge
Giga Guru

Hi, I would suggest generating a report from the sys_journal_field table and filtering it for your requirements. For example, a reopened case will have a journal entry value of "Case reopened by User".

Hope this helps.

Awantika verma
Tera Contributor

Hi Team,

We have requirement to show the case reopen dates with case number when reopen count increase from zero in case SLA report of CSM module , please suggest possible solutions .

Thanks