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

Need foundation for Project report/portlet also links WorkPlan and Time

Highlighted
Greg_S
Collector

Need foundation for Project report/portlet also links WorkPlan and Time

On PPM 9.12. Boss wants me to put together a report/portlet that shows Proj Name/Number, etc, plus status of WorkPlan, Total Hours people have spent on it, and Hours last week in Project. So to start, I found the Project List portlet that has the basic data, such as Project Name, number, planned start/end dates, etc. Usually I can find the data source in Workbench under Dashboard, but this portlet is JAVA.

Can anyone provide guidance such as: where I can find this Java program, or basic query to use which links WorkPlan with Project and Time?

1 REPLY
AlexSavencu
Honored Contributor

Re: Need foundation for Project report/portlet also links WorkPlan and Time

Hi, Greg,

 

i would recommend you to write a custom LIST portlet to accomplish this task.

 

Check out the data model document bundled with PPM - it also contains diagrams to help you see the link between the tables.

 

cheers

alex


--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event