Absent Member.
Absent Member.
517 views

Project Stakeholders

Jump to solution
Hi,

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

Thanks.
0 Likes
1 Solution

Accepted Solutions
Cadet 1st Class Cadet 1st Class
Cadet 1st Class
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...)

View solution in original post

6 Replies
Ensign
Ensign
I hope 'ITG_TRUSTEE' is a releted table.

Regards,
Mahendran M
0 Likes
Absent Member.
Absent Member.
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.
0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class
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...)

View solution in original post

Absent Member.
Absent Member.
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.
0 Likes
Cadet 1st Class Cadet 1st Class
Cadet 1st Class
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.
0 Likes
Absent Member.
Absent Member.

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

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.