Creating a report showing reopened cases

[Rodzula]

Hi

How would one create a report showing all the reopened cases

Many thanks

[AndersBGS]

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

[Rodzula]

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

[David Aldridge]

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]

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