The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Change Projectname in the database

SOLVED
Go to solution
Highlighted
Ramazan1
Regular Collector

Change Projectname in the database

Hello,

 

I need to change 2 project names directly in the database. I read the Data Model Guide and wanted to be sure whether the table kcrt_fg_pfm_project, field PROJECT_NAME, is right to change. Are there any other points to consider?

 

The SQL Update Statement:

 

update kcrt_fg_pfm_project
set project_name='HD1'
where request_id=30333

 

Regards,

Ramazan

3 REPLIES
Jason Nichols K
Honored Contributor
Solution

Re: Change Projectname in the database

KCRT_FG_PFM_PROJECT
PROJECT_NAME
PRJ_PROJECT_NAME

PM_PROJECTS
PROJECT_NAME
Ramazan1
Regular Collector

Re: Change Projectname in the database

Hi,

 

thank for your answer.

Is there a possibility to change the name in the HP PPM Website, e.g. Project Page?

 

 

Jason Nichols K
Honored Contributor

Re: Change Projectname in the database

It is a field on the Request Details (In the header) page.  Make sure it's editable and you can change it, though most of the time, it gets marked as Display Only.

//Add this to "OnDomLoad" event