I was wondering how I could use the "Worklog Author", "Total Logged", and "Date Started" fields that are shown in timetracker reporting in the normal JIRA filter search columns.
I am wanting to make a static dashboard that shows all employees time spent over the past 30 days. Instead of having to go in to the reporting area every single time and change the dates manually.
All I need to see is the "user" and "total logged" for the last 30 days. Is there another way to do this and just have a static page for managers to go to and see all employees?
Could REST API be used to do this?
Unfortunately, Timetracker does not provide any additional JQL function to get these fields yet.
To be clear, "author", "timeSpent", "started", etc. are all default JIRA fields, what you can use with REST API.
You can get a JSON response like this for example:
"timeSpent": "3h 20m",
If I get the Worklog Query Program would I be able to make a page that displays data that looks exactly like the User Quick Summary on Timetracker reporting? If so, how?
Do I need to have Timetracker to use Restful Worklog Query or can I just use the ladder?
Every time I go to reporting on Timetracker the page takes an extremely long time to load, so it doesn't seem viable for me, plus I would like just a static page for the last 30 days.
You don't need the Timetracker to use our Worklog Query plugin.
I cannot describe to you exactly how to build your application, but yes, you can develop something that will show you exactly the same data. You just need to retrieve the work log data using Worklog Query plugin or the default JIRA REST API. Basically, you need to query for the users you want ("author" or "worklogAuthor"), in an interval with 30 days using the "started" field and the current date and summarize the "timeSpent" value for each user. Use the documentations what I already posted in my previous answer.
You can do this as a simple web app, Excel app, Google app, etc. or you can even make a JIRA gadget. (here is the documentation to how).
In the future, we want to add some gadgets like this to Timetracker, but I can't tell you the exact date.
I'm sorry if I was not clear. You cannot exactly query the summarized data. You need to develop some logic to query, select and summarize logged times for users, etc. I can't give you an out-of-the-box solution for your problem, but maybe you can find some customizable dashboard gadget add-on on the Marketplace.
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