Clarity

 View Only
  • 1.  Daily Resource Actual Hours from Other Work, Services, Ideas

    Posted Jan 25, 2017 11:35 AM

    Hello,

     

    here is query that will get you all hours from resource's timesheet posted for a project (tasks):

    SELECT Slice, slice_date, r.full_name, t.prname Task_name, p.name project
    FROM prj_blb_slices s, prassignment a, prtask t, srm_resources r, srm_projects p
    WHERE s.prj_object_id = a.prid and a.prtaskid = t.prid and
    t.prprojectid = p.id and a.prresourceid = r.id and
    p.unique_name like 'Replace with Project Code' and
    r.unique_name like 'Replace with Resource Code' and
    slice_request_id = 2
    How to get actuals from timesheet that are posted for Service, Other Work and Ideas? In other words, from investments that don't have tasks?


  • 2.  Re: Daily Resource Actual Hours from Other Work, Services, Ideas

    Posted Jan 30, 2017 10:52 AM

    Your query would already return hours from the Non-Project Investments.  While those objects don't have a Tasks tab, they do have one task each entered in the prtask table in the database.