How can I report how many times a cases has been reopend? I do not have a reopened option for HR cases.

[Jazmine Morales]

I do not have the "Re Open" option for HR Cases and would like to report on how many times a case has been reopened or if it has been reopened at all. Is there a way to report how many cases have been reopened? 

[Mohith Devatte]

Hello , You can create a custom field in case form which is of integer type and write a after update  BR  with condition saying that when state changes from closed to draft or ready or any other state

Script:

var gr = new GlideRecord('sn_hr_core_case') gr.addQuery('sys_id',current.sys_id); gr.query();

If(gr.next())

{

gr.count field name = gr.count field name; +1;

gr.update();

}

Mark my answer correct if it helps you 

[Karun S]

Creating new "metrics" is not my cup of tea. I prefer simple GUI solutions.

In your case, if you want to see the number to times a case is reopened, simply select "reopen count" from the list of options in "choose columns" in the incident table [incident].

You can use several operators in this filter such reopen count > 2 and so on.

Hope this helps...

[Jazmine Morales]

The problem is that I do not have that option on my list. How could I get that option?

[piotrkopytynski]

I think that OOB you don't get it and maybe the person responding customized that or installed a plugin/update set that included a dictionary entry for that field. I have checked and a Rome release does not provide that attribute OOB for the sn_hr_core_case table.