Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Open a closed project.

Highlighted
Amanjyot
Super Collector

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
Occasional 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
Honored 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.

//Add this to "OnDomLoad" event