It's all about the answers!

Ask a question

Reporting on hours spent on each Timecode

Peter Turvey (993) | asked Mar 13 '18, 12:43 p.m.

I have used the Jazz Report Builder to produce a report of the "Planned Time" and the "Actual Time" spent on some work items. The SQL statement for thisĀ uses the "RIDW.VW_REQUEST T1" and then the "T1.ACTUAL_WORK" and "T1.PLANNED_WORK" attributes.

What I really want to report on is a breakdown of the time spent on each TIMECODE.

i.e. the values that are entered on a Work Item's "Time Tracking" tab, such as "Documentation", "Coding" etc.

Does anyone know how I can edit my SQL statement to get this information ?


Be the first one to answer this question!

Register or to post your answer.