How to extract time spent between two dates ?

Samy Rabih

Hi

We use the 6.1 version of JIRA (on auto-hosted instance), and I face a problem on extracting statistics from our tickets.

In fact, we use the "Time spent" feature to log the time our developers spend on each ticket (sometimes the tickets are re-opened to add extra time).

So, I'm trying to extract the time spent on some tickets "between two dates" (and not the total time spent for these tickets).

But I didn't find any option to filter the timeSpent data.

Have anybody an idea about it ?

Thanks !

Samy Rabih

I used finally a MySQL query (we have access to the database) :

select distinct
  P.pname as Projet
,CONCAT(PK.PROJECT_KEY,'-',Child.issuenum) as Ticket,
Child.Summary as Nom
 
 
  ,replace(sum(WL.timeworked)/3600,'.',',') as Heures
, Type.pname as Type
 
from worklog WL
 
join jiraissue Child on WL.issueid = Child.ID
join issuetype Type on Child.issuetype = Type.ID
join project P on Child.PROJECT = P.ID
join project_key PK on PK.PROJECT_ID = P.ID
 

 
where 1=1
and WL.STARTDATE >= '2013-12-01'    
and WL.STARTDATE <= '2013-12-31'      

GROUP BY
Child.ID
ORDER BY Projet