Project and Portfolio Management Practitioners Forum
cancel

How to find stakeholders in database table.

SOLVED
Go to solution
Highlighted
Korayk
Valued Contributor.

How to find stakeholders in database table.

I attach an image for it. I could not find the table in database.

2 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

Re: How to find stakeholders in database table.

Hi Korayk,

 

You can use any of these functions to get the Project Stakeholder list/name. You only need to pass the project ID in the HP Provided out of the box package.

 

Oracle Package Name - PM_UTILS

 

  1. Get delimited list of user ID's for all stakeholders of the specified project

    select PM_UTILS.get_prj_stakeholders(<project ID>) from dual  

  2. Get delimited list of all project stakeholder usernames for the specified project 

     select PM_UTILS.get_prj_stakeholder_usernames(<project ID>) from dual

  3. Get delimited list of all project stakeholder full names for the specified project 

     select PM_UTILS.get_prj_stakeholder_name_list(<project ID>) from dual
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Korayk
Valued Contributor.
Solution

Re: How to find stakeholders in database table.

Thanks for your response. It is very useful.