Fetch re-opened changes

[AccGold]

Hi Everyone,

I am trying to build the report which can show the “Change Requests” which got re-opened from “Closed’ status to any other status. In other words, report to fetch the re-opened changes.

Do I need to write the script ?

Note: The change requests were closed, re-opened, and then again got closed.

[POOJA SINGH18]

Hi @AccGold 

As per best practice, we should never  reopen a change request. There is a functionality called "Copy Change" that may ease you to recreate another Change Request with the same data.

Also OOB Workflow of change request don't allow to re-open a change request. Have you make any customization to OOB Workflow?

[AccGold]

Hi Pooja,

Thanks for the response!

I agree that the best practices should needs to be followed and the change request should not be re-opened.  I'm not sure about the OOB workflow, but I know with the admin access, we were able to re-open the changes.

So, now we want to create the report to fetch such changes which ever and at any stage got re-opened. The report will be taken as reference for the future monitoring as well.

is it possible ?

[POOJA SINGH18 · Accepted solution]

Hi @AccGold 

you need to create another custom field in your table and when ever it re opened then that field should updated with that date. you need to either modify the workflow or if you do it manually from the change request table then right before business rule . After then you can be able to fetch the report over the field.

Hope it helps and please mark helpful if it solves the issue.

Thanks,

Pooja Singh

[AccGold]

Thank you, Pooja. 

I appreciate your response and the solution. I will try for sure.