Manually modify change request state value

[claystroup]

We have an emergency change req ticket that needs the state to be changed from 'work in progress' to 'closed complete'. That list choice is grayed out even to me with a systems admin role. I have verified that the workflow on this req has completed, the post implementation ctask is closed, the req closure status is 'completed' and that the final step in the workflow before 'end' is a 'set value' '3 (which is closed complete in our system)'. For some reason, the workflow completed without actually setting the state field value to 3. The only documentation I can find is how to change the label for the field or the choices for the field, I cannot find any documentation on how to manually change the value to one that is inaccessible i.e. 'grayed out'.

[claystroup · Accepted solution]

Thank you all for your suggestions. Changing UI actions, etc in PROD just to set a field value in a single record is not a method I would care to employ due to our change management policies.

The Javascript runner is a useful utility, but unfortunately in this case it did not change the value.

One of my coworkers showed me the process for making these types of changes using the REST API Explorer, it is the only way to connect to a specific record in the database tables to change a read only field value since we do not have direct access to the tables themselves. Employing the REST API Explorer (PUT) method successfully changed the value.

Launch REST API Explorer

Select method (Get, Put, etc.)

Select Table

Enter sys_id

Scroll to bottom and click 'Add a field'

Select field to change

Enter change value

Click 'Send'

This process did not require me to modify anything in the instance, took less than a minute, and changed the value.

[Chuck Tomasi]

Hi Clay,

Thanks for the update. Hadn't thought about the REST API Explorer. That's an interesting use for it. Realize that you are making an product data change. It sounds like you have pretty strong change management processes in place so I hope that didn't violate anything there.

[claystroup]

No, changing a value in a field in a table in PROD doesn't violate change management. Changing UI actions, business rules, form layouts, etc that change overall operation must go through change management approval as it affects the entire organization, not just our hospital. We have a separate team in a separate org that we share instances with, and any global change affects their processes as well as ours.

[Nagameshwara pa]

Hi Clay

Press CTRL, Shift, ALT and J together. Then in javascript runner run the below code

g_form.setReadOnly('state',false).

and update the field and save the form.

Thanks,

Pandian