The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Find total time for a period

Highlighted
Mohit_Agrawal
Frequent Visitor

Find total time for a period

HI All, I need to fine total time charged for a time period, for all project, all resources... Just one number: total time charged for a period or for a year.... do you know of any report or have sql query? Thanks
1 REPLY
Erik Cole
Honored Contributor

Re: Find total time for a period

Something like this should work....

Select sum(ae.ACTUAL_EFFORT)
FROM TM_TIME_SHEETS ts
join TM_TIME_SHEET_LINES tsl on tsl.TIME_SHEET_ID = ts.TIME_SHEET_ID
join TM_ACTUALS a on a.TIME_SHEET_LINE_ID = tsl.TIME_SHEET_LINE_ID
join TM_ACTUALS_EFFORT ae on ae.ACTUALS_ID = a.ACTUALS_ID
join KTMG_PERIODS p on p.PERIOD_ID = ts.PERIOD_ID
where 1=1
and tsl.STATE != 5 -- don't include Canceled
and a.TOTALS_FLAG='Y'
AND p.start_date > to_date('1-JAN-16','dd-mon-yy')

//Add this to "OnDomLoad" event