This is more of a language issue then a bug.

 

For a request of any type the Time Elapsed = Time Completed - Time Created, and Time Spent = sum(work logs).

 

I know way back when Time Spent = Time Elapsed, but with work logs this is no longer true.

 

I would update your ReportColumnDetails table, to change the TIMESPENTONREQ to point to sdp.reportcols.mod2.timespent which shows "Time Elapsed" instead of sdp.reportcols.mod1.timespent which shows "Time Spent", or change sdp.reportcols.mod1.timespent Java function to say "Time Elapsed".

 

Oh, and don't forget MM2COMPLETEREQUEST, which is "Time Spent" on a request and points to sdp.reportcols.mod2.timespent "Time Elapsed" in version 8, but should actually point to sdp.reportcols.mod2.auctualtime "Time Spent".

 

Don't know what happened between version 7 and 8, but things took a step backwards instead of forwards.

 

-Ross