With the new worklogs, I'm trying to get a report together that consolidates the worklogs across all modules from the chargestable.  I'm not sure how to get what the worklog was tied to.  Here is the data I am looking for:

 

Origin Type (Request, Change, etc.)

Origin ID

Technician

Description

CreatedTime

Time Spent

 

I am looking to get this data for a specific range - Daily, Weekly, Monthly, etc.

 

I am on pgsql.