Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    12
  • Views views
    177
  • Users 0 members are here
Related
Options

Assignment load portlet Resource Load Breakdown - Assignment Details SQL

puthar

Hi,

I have tried to get the SQL used by the portlet for the Assignement details but not one of the SQL queries in the DEBUG CONSOLE return the information displayed:

I need to create a SQL query to be used for pushing the data into another reporting layer.

We could balance the Timesheet data for the actuals and the Resource capacity but I am struggling to get the data for the Scheduled Effort as per the assignments load details per project/request.

Is there a SQL query that can be shared to assist in getting the Scheduled Effort which will balance with the portlet details?

Thank you.

Regards,

Alfred Puth

iOCO: Senior PPM Consultant

  • Verified Answer

    +1  

    Hi Alfred, 

    Where did you look exactly in the Debug Console? When I check my resource Load/Capacity tab and check the corresponding request (/itg/resource/SwitchResourceTab.do) in the debug console, I see all the SQL used to generate the chart. (hint: search in page for "effort" in the SQL strings).

    The SQL queries are not for the faint of heart and there are more than one needed to generate the chart, but it's all in there.

    Same thing goes if you have an "Analyze Assignment Load" portlet as depicted on your screenshot and opens the "View Resource Breakdown" popup. You'll get all SQL queries in the Debug Console in request "/itg/resource/ViewResourceLoadBreakdown.do".

  • 0 in reply to   

    Hi Etienne,

    Thanks for the feedback.

    I hoped to be able to match the UI output results to one query.

    As you stated it will be multiple SQL statements that will provide the result.

    I just need to work with all the effort related statements to get to the final result as per UI.

    Thanks again.

    Regards,

    Alfred Puth

    iOCO: Senior PPM Consultant

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.