Project and Portfolio Management Practitioners Forum
cancel

Open a closed project.

Highlighted
Amanjyot
Respected Contributor.

Open a closed project.

Hey,

 

 Coul anyone tell me how to open a closed project from backend using sql scripts. What all tables need to be updated for that.

 

Thanks in advance.

2 REPLIES
Ted Power
Regular Contributor.

Re: Open a closed project.

Amanjyot,

 

Use the front-end reopen button on the request by setting the reopen step on the workflow.

 

Ted

Erik Cole
Acclaimed Contributor.

Re: Open a closed project.

I don't know about from SQL, but if you need to automate this somehow you could probably use the ksc_move_request_workflow special command with FORCE_TRANSITION option to bump it to whatever step you want. Look in the commands guide for more info.