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?