Project and Portfolio Management Practitioners Forum
cancel

How to change a field value in the DB?

SOLVED
Go to solution
Highlighted
TurboMan
Honored Contributor.

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
Acclaimed 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
Honored Contributor.

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
Acclaimed 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
Honored Contributor.

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
Acclaimed 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