AnsweredAssumed Answered

Daily Resource Actual Hours from Other Work, Services, Ideas

Question asked by mtuscic on Jan 25, 2017
Latest reply on Jan 30, 2017 by Tim1302647

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?

Outcomes