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

How to change a field value in the DB?

SOLVED
Go to solution
Highlighted
TurboMan
Member

How to change a field value in the DB?

Hi,

 

I need to change the Planned Start Period and Planned Finish Period of projects in DB.

Because, I need a mass update.

PPM 8.04.

 

Any help is appreciated.

 

Regards

TM

5 REPLIES
AlexSavencu
Honored Contributor

Re: How to change a field value in the DB?

Hi, TurboMan,

 

do you need to change the field in the Project Request form, or the start / end  date of the Project workplan?

 

for the first one, you can use the PPM built-in functionality called Mass Update ;)

 

cheers

alex


--remember to kudos people who helped solve your problem
TurboMan
Member

Re: How to change a field value in the DB?

Thanks,

 

I need to change in the Project Request Form.

Becasue, I cannot save.

So, I need to try to resolve this problem  by updating DB fields first and see on the Project Request Form.

 

Regards

TM

 

AlexSavencu
Honored Contributor
Solution

Re: How to change a field value in the DB?

Hi,

the information you're looking for is in the KCRT_FG_PFM_PROJECT.

You should also update LAST_UPDATE_DATE in this table as well as in KCRT_REQUESTS.

Let us know if it works.

Cheers
Alex

--remember to kudos people who helped solve your problem
TurboMan
Member

Re: How to change a field value in the DB?

Alex,

 

You are a legend, thanks very much.

Just a quick update,

After I updated, I have to run cache manager to flush all caches as follows 

./kRunCacheManager.sh A

or rebounce the PPM . 

 

Regards

TM

AlexSavencu
Honored Contributor

Re: How to change a field value in the DB?

Hi,

If you also update the KCRT_REQUESTS.ENTITY_LAST_UPDATE_DATE, then you don't need to refresh the cache or bounce the server.

Remember to provide kudos to people who helped solve your problem.

Cheers
Alex

--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event