I have been trying for the last couple of weeks on a query to present data in the format of the data table of the "Analyze Assignment Load" portlet but in FTE s.
ie Total Capapcity of a reosource; total assignments of the resource; total remaining capacity of the resource and the break of the assignments into projects in FTE.
Though I was able to create functions to be able to pull this data but the query with all the functions to be able to present the data in the format as the data table is taking a huge time to pull data for just one resource pool with 8 resources.
When I say huge time I mean the query is still running and its already 30 minutes since I ran it.
I did try and capture the underlying query in the logs but to no avail. For some reason while most of the other queries are being captured in the logs the underlying query for this data table does not show up in the logs.
Is there any way that I can achieve what I want which is data in FTE for the data table to assignemtn load portlet or does any one have the query to it in FTE?