I'm looking to do a sum of time spent on all issues marked with a particular project and area between a start and an end date.
I'm currently putting this information together manually using a combination of saved filters and the Clark Kent plugin. It's not fun.
I'm looking at the XML API as an alternative to gather up this data programmatically but I can't quite seem to get what I want out of the API -- am I missing something or is this just not possible?
I want to get all the time spent on tickets on a project + area between two dates, no matter who the person was working on the ticket.
This seems to be a pretty heavy-weight query right now. I'm thinking:
- Get a list of tickets that match the project+area filter that span all time. I'm fairly certain I can do this with cmd=search and I don't have to save a filter for each project+area combination I'd want to access this way.
- Get a list of timesheet intervals for this time period for all users and all cases using the cmd=listIntervals call.
- Match cases in the list gathered in step 1 against timesheet entries gathered in step 1 and extract elapsed time from those timesheet entries.
Okay, I've got it down to two API calls. But they'll both return quite a bit of data that needs to be sifted through. Am I missing some easier way to pull these time sheet entries from the database?