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: 

How to find stakeholders in database table.

SOLVED
Go to solution
Highlighted
Korayk
Occasional 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
Honored 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
Occasional Contributor
Solution

Re: How to find stakeholders in database table.

Thanks for your response. It is very useful.

 

 

//Add this to "OnDomLoad" event