I'm using JIRA OnDemand, and I need to report on worklogs. I think I found something that might work, JQL Tricks Plugin, but it's a plugin that is not available in OnDemand JIRA.
Essentially, I need to create an issue filter using JQL that will pull issues and their worklogs (hours) for worklogs entered on specified dates.
These are some JQL Tricks Plugin function that seem to accomplish what I need:
workStartedOn() - Find out issues for which work was started on the specified date and optionally by a specific user. workLoggedOn() - Find out issues for which work was logged on the specified date and optionally by a specific user. workUpdatedOn() - Find out issues for which work was updated on the specified date and optionally by a specific user.
workLoggedBetween() - Find out issues for which work was logged between the specified dates and optionally by a specific user.
Was anyone able to create a JQL filter on worklogs wihtout JQL Tricks Plugin?
There is a ticket open to add JQL Tricks to the OnDemand hosted environment, please vote on it: https://studio.atlassian.com/browse/JST-4710
Also, I found this request to use JIRA JQL to pull WorkLogs and for worklog report
It used to be free, now it's replaced by paid Time Reports add-on, however what is related to the question is still available for free by native JQL clauses worklogDate and worklogAuthor, please see http://www.jiratimesheet.com/wiki/RESTful_endpoint.html for more information.
I've had similar need and found some solution with free Script Runner plugin, however I don't know the On Demand policy in relation to free plugins.
The JQL (extended due to Script Runner) I'm using now is:
issueFunction in workLogged("after 2013/09/01 before 2013/09/30")
Ramiro - Thanks for the quick response. We did purchase the Tempo Plugin. Can Tempo reports pull in custom fields? We have defined a custom field, Category (Development, Support, Vacation, Administration).I'm looking to do a roll-up report based on this category field, how many hours were logged against each category weekly.
Since version 2.6, in Timesheet Reports and Gadgets Add-On there is workedIssues(fromDate, toDate, userOrGroup) JQL function. It returns issues that have a worklog with startDate between specified fromDate and toDate, including.
E.g. JQL query: key in workedIssues("2013/09/23", "2013/09/29", "jira-developers").
Hope you'll find it useful.
I'm using the Timesheet add-on in JIRA OnDemand and finding that queries with this workedIssues function return as expected in the issue navigator but always return 0 issues via the getIssueList action of the CLI (in eirther the filter or search parameter) while queries with other built-in JQL functions return the same in both cases, any idea what's going on?
Sorry, I have no idea, you should probably ask Bob Swift/Appfire. I think rising separate question tagging both plugins could work.
For information, I have just tried CLI plugin, but can't make it work. I use the following command but it is not able to login to server:
$ ./jira.sh -a getIssueList -s http://localhost:2990/jira -u admin -p admin --search "project in TIME" Unable to log in to server: http://localhost:2990/jira/rpc/soap/jirasoapservice-v2 with user: admin. Cause: (503)Service Unavailable
This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs