Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..
212 views

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
0 Likes
1 Reply
Erik Cole Acclaimed Contributor.
Acclaimed 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')

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.