AnsweredAssumed Answered

Trying to find adjusted time in a Query

Question asked by RichWolverton on Oct 25, 2016
Latest reply on Nov 8, 2016 by RichWolverton

We are trying to find the Adjusted time in a query. We can find it if the Timesheet is not adjusted but are getting a null result for Timesheets that are Adjusted. Any insight would be appreciated. Our current query is:

select r.full_name as consultant,
ts.prresourceid,
ts.prid as tsid,
ts.prstatus,
te.prid as teid,
tp.prid as tpid,
tp.prstart,
tp.prfinish,
s.slice_date,
s.slice

from prtimesheet ts
   left join srm_resources r
        on r.id = ts.prresourceid
   left join prtimeentry te
       on te.prtimesheetid = ts.prid
   left join prtimeperiod tp
      on tp.prid = ts.prtimeperiodid
   left join prj_blb_slices s
      on s.prj_object_id = te.prid

where r.last_name = 'Cora'
-- and ts.prstatus = 4
-- and te.prid is not null and te.prid is not null
order by tpid

 

Thanks,

Rich

Outcomes