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 !
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
you can use the tempo plugin, that will give you the ability to find time logged between two calendar dates,
https://marketplace.atlassian.com/plugins/is.origo.jira.tempo-plugin
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.