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

Project Stakeholders

SOLVED
Go to solution
Highlighted
Sevilay
Collector

Project Stakeholders

Hi,

In which table can i find the project stakeholders and how can i relate this to projects?

Thanks.
6 REPLIES
Mahen M
Honored Contributor

Re: Project Stakeholders

I hope 'ITG_TRUSTEE' is a releted table.

Regards,
Mahendran M
Sevilay
Collector

Re: Project Stakeholders

Hi Mahen,

yes you are right.Theoretically all the users related to an entity should be reposited in that table,at least DataModel.pdf says that.
But in real,there is no user in the knta_users table related to trustee_id of the itg_trustee table.In datamodel.pdf,it says that trustee_id must match a USER_ID
in KNTA_USERS.

In fact i want to find all the projects in which a user is chosen as a stakeholder.

Thanks again.
Sascha Mohr
Esteemed Contributor
Solution

Re: Project Stakeholders

Regardless of the data model you can use functions like pm_utils.get_prj_stakeholders(projectID) from the package pm_utils to get whatever you need (resources, project and program managers, stakeholders...)
Sevilay
Collector

Re: Project Stakeholders

Hi Sacsha,

this is very usefull information for me.
But is there any package that gets the stakeholder's name or id as an input and gives the names of the projects related to that stakeholder.
i want to go vice versa.
Thanks.
Sascha Mohr
Esteemed Contributor

Re: Project Stakeholders

Sure, use it like this:
SELECT * FROM pm_projects
WHERE InStr('#'||pm_utils.get_prj_stakeholders(project_ID)||'#', '#30004#') != 0

And put the user_id of the user you're doing the lookup for where the 30004 is.
RBnaerjee
Occasional Advisor

Project Security Settings

Hi all,

 

Any oe has a clue hhow to change security settings of all projects at once in HP PPM.

 

I have to change settigs for 4000 projects ... please help.

 

Regards

Raj

//Add this to "OnDomLoad" event