Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

SQL to get monthly allocations for resources

  • 1.  SQL to get monthly allocations for resources

    Posted May 28, 2013 02:34 PM
    I have to write a report to show that the Resource PLanning, Allocations tab shows (Resource Workloads portlet).

    Has anyone had to recreate this view as a report or know what sql will give me the monthly allocations for resoruces by work item?

    I am close but my sums for the monthly allocations is way over what Clarity's Resource Workloads portlet shows.
    Thanks,
    Joan Kelley


  • 2.  RE: SQL to get monthly allocations for resources

    Posted May 28, 2013 03:25 PM
    See
    101085344

    Martti K.


  • 3.  RE: SQL to get monthly allocations for resources

    Posted May 28, 2013 03:31 PM
    Deepak reports having done it

    13073091

    Martti K.