Can someone help with queries?

Question

I am trying to write a query to pull specific reports for review. Here are the main things I need to know;

* how much time are developers (not QA) logging on Tasks and Stories and the bugs associated with those Tasks and Stories?
* how accurate are the developer in time estimates as compared to the answer from #1?

Here is an example of the query to use( one specific project):

project = "" AND issueFunction in linkedIssuesOf("project = "" AND issuetype in (Task, Story) AND timespent is not EMPTY") ORDER BY issuetype ASC

Is there a better one to use? Will this pull the information we need?

caglad · Accepted Answer

At its simplest, you can download all fields to Excel and use the work log field(s) by user. This got to be tedious for us and we are now using "worklogs" app which can pull in user groups (developer) from a filter to see the information you are looking for.